Can i keep columns locked while requesting a row update
I need user to view many rows, but only have ability to edit several columns. I locked the columns in the sheet; however when i tested…it appears the user can still edit the column values when they receive the row update form via email. How can I enforce the locked columns, while still giving visibility/read access to only those columns and have them edit other columns in the row?
Answers
-
Hey @lorihughes
There has been a similar conversation on a previous request, check it out here - the conversation was the reverse of what you are asking (i.e. they wanted users with Admin permission to be able to edit whereas you do not), but the answer and insights are the same. I hope this helps!
Marcé Holzhauzen
Dare to try
If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives