Permissions to edit cells
Hello all.
I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status.
The question is possible edit permissions on cells to avoid that any user could change it?
Thanks
Best Answer
-
Yes, as long as your collaborators are shared as an editor on the sheet. You can LOCK specific columns by right-clicking on the header and choosing Lock Column. See screenshot below.
Answers
-
Yes, as long as your collaborators are shared as an editor on the sheet. You can LOCK specific columns by right-clicking on the header and choosing Lock Column. See screenshot below.
-
Only admins can adjust locked columns. So you want to make sure that users are shared correctly on the sheet or workspace!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!