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.
Column Editing Restrictions
Hello,
I have approximately 50 users that routinely review and update the data in columns in my SmartSheet. However, for 3 columns in my sheet, I need to restrict 47 of my 50 members from being able to update the data in those specific columns. The rest of the sheet can be updated by any user. Locking the column allows only admins to update, and I do not want to make any users an admin, so is there another way to "lock" the column for a portion of my users while keeping it "unlocked" to the rest?
Thanks!
Comments
-
There is no foolproof way to do this. You could hide the columns in the main sheet and serve reports to the various individuals, gathering the 3 columns to those who have access to their report.
-
Consider using automated update requests.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives