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
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!