Is it possible to make an update request, but only allow editing of certain columns? I want them to be able to see certain columns, but not change them.
Yes, you can adjust what columns are included by clicking edit next to include when composing the update request. See my screenshot below.
Ohhhhh... but the seeing and not editing part might be possible by locking the columns and rows and making sure that the people you are sending the update request to are shared as editors and not admins on the sheet you are requesting the update from. See here for more information: https://help.smartsheet.com/articles/522077-locking-unlocking-columns-and-rows
Yes, they won't be able to edit the columns that are locked.
I hope this helps you!
Andrée Starå - Workflow Consultant / Get Done
Workflow Consultant / CEO @ WORK BOLD
Oh, OK. I see... Thanks a lot!
You're welcome. Glad we could help!
Happy to help!
Has anyone had issues with this with automated update requests? When we send manually the locked fields are not editable but in the automated request they are.
Posted the answer from your other post here.
It depends on what permissions you have for the user in Smartsheet. If they have access to change it in Smartsheet, then they can change it in the form.
Hope that helps!
Have a fantastic weekend!
Workflow Consultant @ Get Done Consulting
Is there any way to change view/edit of update request items without locking columns and changing admin access? It would be nice to have a simple "Include in Update: Yes/No" and then a "View Only/Edit Access" or something in the update request builder.
Jason Tarpinian - Sevan Technology
Smartsheet Platinum Partner
Have you considered limiting which columns you are sending them in the update request? You could also consider creating a web-published report that they could use to see and not update the rows they have. You could include the link to the report in the update request for their reference and only send them the rows they need to edit.
I would also check to make sure they don't have an editable role in the sheet that would allow them to edit the locked rows.