Limit Cell to a Single Modification

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.
Answers
-
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 TriggeredCondition: 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.
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!