Limit Cell to a Single Modification

GGSF

Is it possible to lock (prevent changes) a cell after it has be modified? For example, if I have check box, the user can only click it once. If it is date, it will be auto filled based on the check box, the no changes are allowed.

Kerry St. Thomas

The short answer is …don't surface the important cell to the end user.

The long answer - there IS an automation to lock an entire ROW, but not to lock a single CELL. So for example, if you want to record a date based on if a check box is ticked - but only the first time that box is checked - you'd set up an automation as follows:

Trigger: When Rows are Added or Changed
When Checkbox changes to Checked
Run Workflow When Triggered

Condition: Where Datestamp is Blank

Record A Date in Datestamp

Keep the Datestamp column HIDDEN and LOCK the column as an Admin or Sheet Owner (if end users have access to the sheet) or just don't include the Datestamp column in a report if you can just surface the report in a WorkApp.