Form and Arrayformula

I am using a Form to fill the rows of a GS Sheet whose last column has a Countif function with Arrayformula to count all the students present in non-empty rows. But since this morning, the added line is placed at the bottom of the sheet whereas until then it has been added on the first empty line. Glide recognizes all cells of the Arrayformula as non-empty. Is this a bug or a lasting change?

That is normal. It has always been that way when using arrayformulas. Glide will not touch a row that has a formula applied to it…even if the result of the formula is blank. It’s still a populated row. You just need to delete all empty rows.


Thank you very much

1 Like