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?
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.
You can write the following formula in the first row:
This is what I do… if the ColumnName is “Price”, you can have the first row as…
This will have the Header name as “Price” and it will also hold the Arrayformula logic too.
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.