Newly added rows do not extend formula columns, leaving some calculated columns empty

When a new value is added using the icon, lines containing formulas or functions are not written data, but a new line is created at the end of the worksheet.

My app’s URL:

This is not an error, this is how spreadsheets work, sadly.

Here’s what to do about it:

1 Like

@Alex_Calandrino One thing I would suggest to add to the tutorial that @david linked to is that you should delete all empty rows on any sheet that you use array formulas on. The reason for this is not needed for Glide, as it does ignore empty rows. It is good practice so you don’t have to scroll all the way down to row 1001 to see the latest row that was added. Because of the arrayformula the sheet thinks it has data all the way to the last physical row of the sheet, not the last row of data. This will save you a lot of head scratching when you are wondering why you can’t see what was just added.


I managed to solve, thank you very much for helping

1 Like