Hi is there any way to prevent users from deleting rows in our sheet? We need them to collaborate with the sheet but NOT delete. Unfortunately despite telling our users to not delete the odd few still do and it impacts our numbering system
You could give them viewer only access to the sheet then provide them with a report. Reports can be edited, but rows cannot be deleted from them.
Hi @Julie Morrison
Unfortunately, no, not really, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could either (depending on the access the users have) lock the row(s), or use the premium add-on, Dynamic View.
Would that work/help?
I hope that helps!
Happy Holidays and Happy New Year!
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 PARTNER & CONSULTANT / EXPERT
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Just a quick note!
@Paul Newcome's suggestion is a good one, but they would also need to have Editor permissions on the underlying sheet still, in order to make any edits through a Report. (See this article on Report sharing permissions.)
Ugh. Thanks for the correction @Genevieve P.
Thanks for the responses, I've raised an enhancement request as per suggestion. In meantime we hope our colleagues will avoid the delete button :)
Happy to help!