How do I prevent the user from deleting rows while allowing him to edit them?

MUSTAF BAROUD

How do I prevent the user from deleting rows while allowing him to edit them?

Jason P

HI @MUSTAF BAROUD

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.

J_B

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.

Jason P

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? https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?_gl=1*7vssa3*_ga*MTg4MTczODcyMy4xNzEyMjY3NDQ3*_ga_ZYH7XNXMZK*MTcxNjQxMjM2OC40My4xLjE3MTY0MTI2MjMuNTEuMC4w*_gcl_au*NDI5ODI1NzAwLjE3MTA5MDA1MTc.&_ga=2.96493407.1731045132.1716149924-1881738723.1712267447

J_B

@Jason P I hadn't. But I have now. Thanks!