I think there is a bug. I added a formula to the entire column using ArrayFormula function. This made empty cells in that column as “#N/A”. Even though these rows are actually empty, just because of the “#N/A”, it counted towards the quota.
Not a bug. Just make sure you add the piece about checking for length of a known always filled column and delete any empty rows.
https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/calculating-columns
1 Like