How do I revert to a previous version of a smartsheet that I was working on?
I was working on my smartsheet this morning and I am not sure what happened, a cross-sheet reference was added (I did not intend to do this). Following this, all cells that were initially populated with numbers, reflected 0. I double-checked the formulae and they are all accurate, referencing the correct sheet. I am not able to identify what this "Cross-Sheet Reference Added" is (refer to screenshot of activity log). I need to revert back to the version before this cross sheet reference was added.
Any help/advice is highly appreciated. Thanks!
Best Answer
-
Hiya!
Jumping in here with additional resources for anyone else with the same question:
If you're on a Business or Enterprise plan, you can request a Sheet Snapshot from the Activity log from when a change was made. This will email the owner of the sheet an Excel file you can use to copy/paste back in your previous data. (See: Request a sheet snapshot).
Any plan type can also check the cell history to see what used to be stored in that cell.
For this specific instance, it sounds like a {cross sheet reference} was changed to point to a different column. You can use the Sheet Reference Manager to edit/update your formula references.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
I would suggest that you get with your account rep. If the change occurred fairly recently there is a chance they might be able to restore it for you.
As a future note, for any critical sheets there is an option (depending on your licensed plan) for Request a Backup. This will allow you to schedule backups on a sheet or workspace at regular intervals so you could restore if something like this happens in the future. I'd recommend setting it up on any critical sheets you might have.
-
Hiya!
Jumping in here with additional resources for anyone else with the same question:
If you're on a Business or Enterprise plan, you can request a Sheet Snapshot from the Activity log from when a change was made. This will email the owner of the sheet an Excel file you can use to copy/paste back in your previous data. (See: Request a sheet snapshot).
Any plan type can also check the cell history to see what used to be stored in that cell.
For this specific instance, it sounds like a {cross sheet reference} was changed to point to a different column. You can use the Sheet Reference Manager to edit/update your formula references.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives