Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Auto Lock columns or rows through formula



  • Genevieve P.
    Genevieve P. Employee Admin

    Shaine's link above has details on how to set up an automation that would lock the entire row should a specific criteria be met (ex. a checkbox checked but no date in the End Date column). However, this automation would only take place once the user had saved the sheet, so if they make changes while also checking the box these changes would save at the same time. It would also lock all columns in that row, including the blank date cell, so they would have to reach out to the sheet admin or owner to unlock the row and update the information.

    When you have a moment, please submit an Enhancement Request for only locking specified columns, and not the whole row.

    As an alternative, you could create an automated update request that sends to the approver only if the "completed" box is checked but the "end date" column is empty, requesting that they fill in the date.

This discussion has been closed.