Update Request-View only
I need the ability to add columns to an update request to the person receiving the request knows the detail behind the request, but only want them to be able to edit specific columns. Is there a way to make columns view only in an update request? I tried locking the columns and that did not work-you can still edit all.
Answers
-
I don't know if this would work for you, but something that we've done is to include the column data that we don't want edited in the message that is sent with the update request and then only include the columns that need updated in the actual form they fill out. Does that make sense?
-
@ChloeSmith How do you include it in the message for an automated alert someone?
-
I hope you're well and safe!
To add to Chloe's excellent advice/answer.
- You can use the Placeholder feature to include information from the row in the message.
- Also, if they are shared as an Editor or lower and the column(s) are locked, they won't be able to edit it.
Would that work/help?
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 support the Community by marking it Insightful/Vote Up or/and as 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.
-
Photos usually help me a bit, so I screenshot what I was thinking and how we've used it in our case management.
The areas between the brackets populate into the message and then they just fill out the form that is sent with the Update Request.
Does that help/make sense?
-
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.
-
@ChloeSmith -thank you that worked!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives