Limit Cell to a Single Modification

Options

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

  • Kerry St. Thomas
    Kerry St. Thomas ✭✭✭✭✭
    Options

    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.

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!