Sharing a sheet | specific columns for access
We are using the API feature and have shared a sheet with one of our vendors. They have asked if I can share the sheet that has been created with more members of their team, but they only want the new members to be able to access and update 2 of the columns on the sheet. Is it possible to share the entire sheet with people and set it up so they can only update certain columns?
Thanks in advance
Best Answer
-
The only thing I can think of is to lock all columns that you do not want altered. This way they would only be able to change the columns you want updated.
Answers
-
The only thing I can think of is to lock all columns that you do not want altered. This way they would only be able to change the columns you want updated.
-
Thanks Michele, that is kind of what I was thinking as well. Is there a way to only lock certain columns for certain individuals or would the column lock be global?
-
To add to Michelle's excellent advice/answer.
A solution that would be perfect for this use-case is the premium add-on, Dynamic View.
Is that an option?
More info:
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives