Can one undelete a full Row once it has been deleted and then the sheet saved?
Answers
-
Unfortunately that is not an action that cannot be undone. You would have to look through the Activity Log and re-enter the row.
-
Hi @Paul Rusek
I hope you're well and safe!
To add to Paul's excellent advice/answer.
You can check the Activity Log and possibly request a Snapshot from the change.
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Unfortunately, Smartsheet STILL does not have the ability to fully recover deleted rows. Sure, they may be able to send you an Excel style backup, but you lose your: Cell history, conversation thread, attachments, formatting, etc etc etc. You 'might' get the raw cell contents back, but that's basically it.
As it stands, 7+ years on and fully, completely, and unequivocally aware, Smartsheet still has the behavior that if someone can edit a single cell within a row of a sheet - they can delete the entire row! And, they can delete it without even getting a pop-up message to ask them if they're sure they want to delete it! (which is funny, because if they try to unlock it they get a pop-up - but if they try to delete it, they succeed without even being questioned)
And, as if it being absurdly easy to lose data wasn’t enough of a kick in the pants, they also still don’t have a true backup option available. Meaning, if you lose a sheet/row/etc – all they can provide you with is a flat excel sheet with a pile of unlinked attachments. All cell history, formatting, links, etc are gone gone gone.
Feel free to review the following community posts, and then decide if you'd like to open an enhancement request on this 7+ year old issue.
Smartsheet: PLEASE do the following:
1. IMMEDIATELY (stop-gap) Implement a pop-up message whenever someone tries to delete a row. (this is already done for the 'unlock row' feature, and should be fast and easy enough to implement for 'delete row')
-zero impact on existing user rights
AND
2a. (solution) Implement a change to the software that will allow sheet owners to prohibit deleting any row that contains a locked cell/column.
OR
2b. (solution) Implement a new user level that is "Editor - safe" where the user has all the rights of an Editor but where the 'delete row' functionality is greyed out. (There is only one permission difference between 'Editor - cannot share' and 'Editor - can share', so the precedent is there.)
Here is my ongoing (and incomplete) list of how many times Smartsheet has ignored this problem:
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
February 2016
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
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
November 2018
https://community.smartsheet.com/discussion/activity-logrows-deleted#comment-124356
July 2019
https://community.smartsheet.com/discussion/52766/deleted-content-in-a-row
July 2019
September 2020
May 2022
June 2022
https://community.smartsheet.com/discussion/91973/how-can-i-track-deleted-rows
Yes, Smartsheet, you still need to fix this PROBLEM, BAD DESIGN, FLAW!
-
@Brad Jones s Here is a link to the new Product Enhancement Request area in case you wanted to go ahead and submit it...
-
This is already something that I have submitted several times over the past 7 years.
With any luck, they will consider it.
-
I am confused as to why this is not addressed. So many users are in pain for not being able to prevent rows being deleted. I too have submitted enhancements that never seem to get addressed. Super frustrating. I should write a book about "SS Workarounds".
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
