Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Lock Column Settings
Hello all!!!
Quick question I feel like I know the answer to. But is it possible to change a lock column setting so the column locks after a condition is met? For my example a column to only lock after a status is changed to a certain value.
Best Answer
-
Absolutely! You can create a Lock Row automation like below. I believe once it is locked only Owners and Admins can still edit.
Answers
-
Absolutely! You can create a Lock Row automation like below. I believe once it is locked only Owners and Admins can still edit.
-
Thanks!!! Is it only for the whole row or can I just lock just 1 column with the automation? @Samantha S.
-
No problem! That's for locking rows only. To lock a column, right click on the header and choose Lock Column.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Can I link a Smartsheet report in a form. My form will be for a person to confirm info from a report is correct. So I want the user to be able to view the report while filling out the form.
- I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (de…
- Hi All! Quick question - I am working on a form with a lot of yes or no questions, and I decided to display them as horizontal radio buttons. They are all circles except for one question, which shows …
