Need some users to have the ability to update certain columns
Hi,
We are using a Smartsheet to track order progress from start to finish. The sheet has many columns but we have 8 dropdown columns that indicate completion in certain departments...Department A, Department B...etc. How can i grant access to the leaders of each department yet protect the rest of the columns that do not pertain to order completion? I know I can lock the columns but i want to make sure they don't accidently slide the rows up or down either because the rows are in a specific sequence using the row number and only the owner needs the ability to move those. The other issue is I'd really like to provide the share to the department heads with them only seeing the order number and the department complete columns. I'd like to have them to use an iPad and it would be much easier for them if they only saw the columns they need.
Thanks.
Shea
Answers
-
Create a report that they access and make changes to the sheet from which only has the columns you want them using. They can make changes only to approved columns from the report and not the sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!