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!

Screen Shot 2021-09-21 at 12.55.25 PM.png

Find more posts tagged with

Accepted answers

Genevieve P.

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

All comments

David Tutwiler

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.

Genevieve P.

Hiya!

Jumping in here with additional resources for anyone else with the same question:

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.