Is it possible to retrieve a sheet containing the exact details from an specific date?

Maei

I accidentally replaced with new information the sheet that should not be changed. After a month, I was requested to restore the original data from October 2022. :(

Andrée Starå

Hi @Maei

I hope you're well and safe!

If you look in the Activity Log, you can request a Snapshot or try recreating the sheet with the available information.

Would 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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Maei

Thanks for your prompt response, Andree! The activity log only shows row no. and that cannot tell which line item does it refer to. Say on the activity log, it says:

I cannot identify which task has a changed forecast completion. :(

Andrée Starå

@Maei

Happy to help!

Can't you use the "BE19/017" to find it?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Maei

BE19/017 is the name of the sheet and every row has it

Andrée Starå

@Maei

Ok, I see.

If you haven’t already, I recommend submitting a support ticket through the new Smartsheet Support Portal.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hiya! Just jumping in here 🙂

In the Activity Log, if you find the date where you made the changes, you can download a Sheet Snapshot (that Andrée mentioned) which will give you all the data from a specific point in time. See:

Request a sheet snapshot | Smartsheet Learning Center

https://help.smartsheet.com/articles/2482574-sheet-snapshot

If you are a licensed sheet owner or admin, you can request a snapshot of your sheet.

If you're looking just for one specific row, and it's moved from being Row 107 (in your screen capture), then I would suggest putting a filter on the sheet to find the date of 13th Oct 2023. Then you can right-click on cells and check the individual Cell History if needed.

Let me know if that helps!

Cheers,

Genevieve

Maei

Thanks Genevieve! The Cell History makes sense but there are rows that have already been deleted :(

Genevieve P.

Hi @Maei

Deleted rows and data will be available in the downloaded Sheet Snapshot 🙂