Counting of rows towards allowed limit

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.

1 Like