3

RIGHT NOW:  

Implement a pop-up warning to alert someone and verify that they want to delete a row.  You do it for unlocking rows, and that's nothing compared to deleting a row.

SOON: 

Give us a new user level with edit access but no ability to delete rows

or make it impossible to delete a row if any cell in that row is locked (even if by column)

 

Currently, any editor can delete an entire row and there is now way to stop them.  Restoring a row from a backup copy does NOT restore the cell histories or other tracking information related to the cells/comments/attachments/changes.

 

This is a long running issue.  Please see the following posts:

 

June 2015

https://community.smartsheet.com/discussion/rows-being-removed   

August 2015

https://community.smartsheet.com/discussion/revert-old-version-sheet

August 2015

https://community.smartsheet.com/discussion/avoid-shared-person-delete-my-row     

August 2015

https://community.smartsheet.com/discussion/conditional-lock

August 2015

https://community.smartsheet.com/discussion/find-deleated-items     

October 2015

https://community.smartsheet.com/discussion/retrieve-deleted-data

January 2016

https://community.smartsheet.com/discussion/form-and-sheet-functionality-available-security-levels-users   

February 2016

https://community.smartsheet.com/discussion/delted-section-my-worksheet-and-undo-button-does-not-go-back-far-enough      

March 2016

https://community.smartsheet.com/discussion/prevent-deletion-rows-if-it-contains-locked-cells          

May 2016

https://community.smartsheet.com/discussion/allowing-team-members-update-smartsheet    

June 2016

https://community.smartsheet.com/discussion/prevent-deletion-rows-enhancement-request-again    

June 2016

https://community.smartsheet.com/discussion/delete-rows-employee-avoide-tasks-completion         

June 2016

https://community.smartsheet.com/discussion/deleted-rows-there-way-find-out-who  

July 2016

https://community.smartsheet.com/discussion/historychange-deleted-rows    

October 2016

https://community.smartsheet.com/discussion/block-rows-been-deleted-editor

February 2017

https://community.smartsheet.com/discussion/admin-deleted-bucket 

March 2017

https://community.smartsheet.com/discussion/retrieving-lost-data

March 2017

https://community.smartsheet.com/discussion/viewing-deleting-rows

June 2017

https://community.smartsheet.com/discussion/web-form-submissions-disappearing   

July 2017

https://community.smartsheet.com/discussion/retaining-deleted-info  

September 2017

https://community.smartsheet.com/discussion/external-collaboration-communication-outside-company-contacts

January 2018

https://community.smartsheet.com/discussion/adding-back-deleted-rows

March 2018

https://community.smartsheet.com/discussion/overwritten-sheet#comment-67946

June 2018

https://community.smartsheet.com/discussion/questions-new-user#comments

July 2018

https://community.smartsheet.com/discussion/retrieve-deleted-sheets

July 2018

https://community.smartsheet.com/discussion/how-avoid-deleting-rowcolumn-smartsheet

August 2018

https://community.smartsheet.com/discussion/can-free-collaborator-delete-line

November 2018

https://community.smartsheet.com/discussion/activity-logrows-deleted#comment-124356

 

 

Again, remember that even with a ‘backup’:

1. You will not be able to restore any cell history.

2. You will not be able to put the comments back in with the correct layout.  (time/date/user stamped, etc)

3. You will not be able to restore the original value of any system column where an index was created.  (e.g. a unique ID or counter)

4. You most likely will not be able to restore the attachments correctly because even with a backup none of the attachments have markings to show what row they were attached to.

So yes, you may be able to restore the latest cell value, but you have lost so much.

 

This problem needs to be fixed, and is important, but has not been given the attention that it deserves.  Please fix this Smartsheet.

Comments

I'm all up on this one. Count my vote, and then count it again.

User Backups also do not include dashboards or reports. 

It would be nice if you could lock rows and columns then exclude certain fields. 

This can be accomplished by locking some columns then only the unlocked fields can be edited. 

Here's the big problem.  If you lock rows then the fields you left open to edits are now locked. 

If you don't lock rows then an editor can still insert or delete rows. 

Smartsheet, if you're listening, this is a deal breaker for using your tool at our National Government Laboratory as far as our Procurement department is concerned. This flaw in your system allows anyone to delete any rows that contain historical data and attachments that are required for our record documents.  Is this really not on top of your list of priorities?  Can we all talk a little louder on this?