August 9, 2022
I have a Table and in some columns I am using formulas.
I want to lock these columns to avoid users' entries. But if locked the users cannot add a new row (I do not want Macros). And the new row must be at the bottom of the table.
So I want users to be able to add new row at the bottom of the table, with the formulas auto-dragging down, without the users to be able to write in formula cells.
Is that possible?
February 13, 2021