Add row in googlesheet with the app

[Darren_Murphy]

@Rodney

So, is there a way to add row in empty rows with formulas ?

No, Glide will see those as non-empty and will add new rows below.

Are these formulas that you copy/paste down as new rows are added?
If they are, you would be better off replacing them with arrayformulas. See below for more on that:

Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts

Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job.

1/ Definition

Arrayformula is defined as “a range, mathematical expression using one cell range …

Even better would be to get rid of formulas in your Google Spreadsheet altogether, and do all calculations in Glide using computed columns. Whether or not that is the best idea depends on the purpose and use of your App.