Alerting Somone So they can only see a certain row in a sheet
Good afternoon
We want to start using Smartsheet to issue purchase orders and keep a PO Log but we want the people in our "Contact" column to only be able to see the row that pertains to them. Is there a way to do this?
Thank you
Best Answer
-
ahhhhhhhh perfect! Thank you
Answers
-
Perhaps this will answer your question? https://help.smartsheet.com/articles/522214-creating-reports
-
Hi, so, we issue a PO and in our contacts column we put our Admin (works for our company) that will issue the PO and the person that the PO gets sent to by our admin. So they both get an alert via email but we only want sandy to have acess to the sheet and not the person getting the PO
Does that make sense?
-
If the other person is not shared to the sheet, they should not be able to view it even through links in an email. If they click on the link, it should take them to a screen that lets them know they don't have access.
-
ahhhhhhhh perfect! Thank you
-
HI Paul, so it worked but they get a button that asks them is they want the sheet owner to grant access and when they click that we get an email asking us to grant them access. Is there a way to not have them have the option of asking for access?
Thanks
-
Unfortunately you cannot remove that option. You should be able to include a custom message though letting them know something along the lines of
"This is just a notification. No further action is required."
Or something like that.
-
Thank you
-
Hi,
A solution that would be perfect is the premium add-on, Dynamic View. Is that an option?
Would that work?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Please help the Community by marking the post that helped answer your question or solve your problem with the accepted answer. 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.
-
Happy to help! 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives