If user deletes 1st row, he loses array formula

i have a button that links to a sheet where many products are listed. the user can edit and delete these products. in my google sheet, there are array formulas in many of the columns. if the user decides to delete the 1st product, he loses the information of that column for all the other products. is there a workaround? or am i being dumb?

2 Likes

A trick to make this work (until we support formulas in Glide) is to write all of your formulas in an empty first row. Glide will skip the empty row, so nobody can edit or delete it.

Check out how we do it in the Issue Tracker template (sheet):

3 Likes

You can write the following formula in the first row:
ARRAYFORMULA(IF(ROW(A:A)=1,“column_title”,IF(ISBLANK(A:A),your_formula)))

2 Likes

This is what I do… if the ColumnName is “Price”, you can have the first row as…

={“Price”;ARRAYFORMULA(…your logic…)}

This will have the Header name as “Price” and it will also hold the Arrayformula logic too.

3 Likes

Besides backups of the spreadsheet, for most complex arrayformulas I copy the text of them to the cell notes as a quick backup that can easily be copy and pasted back into the cell.

2 Likes