How do I prevent the user from deleting rows while allowing him to edit them?
How do I prevent the user from deleting rows while allowing him to edit them?
Answers
-
There is no way to prevent someone with Editor level from deleting a row. You can lock a row or coloumn however this also prevents input from the same. Can you control the points leading up to where they are deleting? example, if at a tick box on an order fulfilment, could you then introduce automation to lock the row? https://help.smartsheet.com/articles/522077-locking-unlocking-columns-and-rows
Cheers.
Cheers.
-
This has been suggested before over the course of a few years. There needs to be a means to do one or all of the following:
- Limit row deletion to only the sheet owner
- Display a visual warning/confirmation box to safeguard against accidental deletions
- Have a means to restore a deleted row with comments and attachments
Hoping to see this as an enhancement sooner rather than later.
-
Hey @J_B
Think you're on the money "Limit row deletion to only the sheet owner"
Have you put this FWD as a suggestion?
Smartsheet FormsCheers.
-
@Jason P I hadn't. But I have now. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate answers to the sheet. However, I don't want them to be able to see what other …
- Good afternoon, In reviewing the question that Nino Chkhikvadze posted on 7/30/20, and the response from Andree Stara, Community Champion, on the same date, would it be accurate to say that an unlicen…
