Restrict Editing of Sheet
Hello,
I am working on a project for a colleague and they have a request I have not considered before. I created a sheet and a form to collect data. They would like to restrict editing of each row of data to the person who submitted the form for that row. I know who submitted it because one of the questions is their location, and then through a vlookup formula, I bring in the contact for the person who submitted it. Is it possible to do this? Through Dynamic View or through the new filtering options, I can restrict who sees what data on a dashboard, but I'm not sure about restricting the ability to edit. It's almost like they want the ability to lock the data for some people, but not for everyone. If that wasn't a hard enough request, they would also like for anyone to add comments or attachments, but just not be able to edit the actual data in the row. Is this possible?
Thanks.
Best Answer
-
Hi @M. David
Dynamic View would probably be the best option.
I hope that helps!
Be safe and have a fantastic weekend!
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.
Answers
-
Hi @M. David
Dynamic View would probably be the best option.
I hope that helps!
Be safe and have a fantastic weekend!
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.
-
This was a reliable option, however we won't be implementing it. The look of DV within a dashboard has hindered its usage at our company. The reports pulled in look much cleaner, so that is what my colleague wants to go with. Thanks.
-
You're more than welcome!
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
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives