Assigned to // Contact List
Hi all,
I have an equipment tracker sheet that has an Assigned To column set as Contact List.
I came to realize that regardless this sheet is not shared with them, they are able to change/edit/modify the cells of this tracker sheet.
I don't want anybody to edit those cells except the ones that are already in the shared list with edit rights.
Is there a way to avoid this? Otherwise I'll change column properties from contact list to normal, but if I do that, my automation will not work, as there is an automation that sends weekly reports to the asset owners (assigned to//contact list).
Thank you for the support.
Answers
-
They should not be able to change anything if they are not shared to the sheet. Is the sheet in a workspace that they are shared to or are they part of a group that is shared to a sheet?
How exactly are they accessing it to change it?
-
Hi Paul, not at all, those contacts are neither in the workspace sharing, or in the sheet sharing. I need to resolve this issue asap
-
I will check with them to see how they are accessing
-
@Paul Newcome I came to find out the way, you can see above.
On the automated Smartsheet mails, there is section that allows them to reach the sheet and update it.
Here is the screenshot of my automation below
While I was checking the automation, I already noticed my mistake and fixed it, I don't know how, Request an Update was chosen as the action item and that allowed them to edit sheet. Now I changed it as Alert someone, and I don't think it should be an issue now. Thank you
-
I hope you're well and safe!
Excellent! Glad you figured out the issue!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Please support the Community by marking your post with 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
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives