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
- 67.5K Get Help
- 467 Global Discussions
- 156 Industry Talk
- 511 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hello! I am very new to smartsheet - lots to learn! I have a dashboard that has a metrics table at the top which is from a report. The report is a simple table which uses =SUM equations to get the yea…
- Hi all, long time listener and first-time caller, I was unable to physically select the "best practices" category, so this goes here. I work for a home builder, and we have a specification grid we uti…
- Hi everyone, I've set up a smartsheet with a form for our employees to sign up for an internal training program. One of the form fields asks for their manager's email, and I need to notify different i…
