Restore a backup version of a sheet

Corentin Dal Farra

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

Genevieve P.

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

Kimberly Loveless

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.

Corentin Dal Farra

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

Kimberly Loveless

@Corentin Dal Farra I am not sure of the plan for sure, I would think it might be enterprise

Andrée Starå

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.

https://help.smartsheet.com/articles/506499-back-up-your-data#toc-schedule-weekly-recurring-backups

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!

Corentin Dal Farra

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

Andrée Starå

@Corentin Dal Farra

Excellent!

You're more than welcome!

Nasir@EBC

Hi All

Can we restore a backed-up version of smartsheet data?

If yes, then please let me know the procedure.

Thanks

Genevieve P.

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