Restore a backup version of a sheet
Hello everyone,
I have lost some rows in my sheet when I saved the sheet after 10 minutes of inactivity.
I can't find them. As it is very critial, do you know if Smartsheet have some copies of every sheet and can restore an old version of the sheet ?
For information, I did not activated any saving or backup as I did not know that these features existed in Smartsheet.
Thank you for your help,
Corentin
Best Answer
-
Hi @Nasir@EBC
If your plan has access to the Activity Log in a sheet, you can find a specific change that happened in the sheet and download a Snapshot from this point in time. It won't change your current Smartsheet sheet, but the owner of the sheet will receive an Excel file emailed to them with the contents of the sheet from that point in time.
Please see this article for more information: Track the History of Changes with Activity Log
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
You can contact Smartsheet support and they can pull a previous version depending on when they last have it saved. If the lines you lost were just added today as well I don't believe they would have it. One thing to note is they will send you the file as a CSV and you would have to import it to Smartsheet so any formulas or formatting wouldn't carry over.
You can also view the activity log and it should show what has changed and the rows could be recreated.
I would definitely recommend setting up reoccurring backups on your side as well that way at least once a week there is a backup you have easy access to.
-
Hi @Kimberly Loveless ,
Thank you for answer !
We checked the activity log but nothing was found. After exploring the sheet we found that the rows were moved 1000 rows below (quite strange).
Do you know what licence plan we need to set up a backup ? Either manually or automatically ?
Thank you for your help, have a nice day !
Corentin
-
@Corentin Dal Farra I am not sure of the plan for sure, I would think it might be enterprise
-
Hi @Corentin Dal Farra & @Kimberly Loveless
I hope you're well and safe!
You can use it on all multi-user plans.
Schedule Weekly Recurring Backups
If you are a licensed user on multi-user plan, you can schedule weekly recurring backups for all sheets in your Sheets directory and any workspace that you own or to which you have Admin-level permissions.
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 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 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.
-
Hi all,
Thank you for your answers @Kimberly Loveless and @Andrée Starå
I will try not to forget the backup from now on :)
Have a nice day,
Corentin
-
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.
-
Hi All
Can we restore a backed-up version of smartsheet data?
If yes, then please let me know the procedure.
Thanks
-
Hi @Nasir@EBC
If your plan has access to the Activity Log in a sheet, you can find a specific change that happened in the sheet and download a Snapshot from this point in time. It won't change your current Smartsheet sheet, but the owner of the sheet will receive an Excel file emailed to them with the contents of the sheet from that point in time.
Please see this article for more information: Track the History of Changes with Activity Log
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives