Restore multiple cell changes from Snapshot

Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful.

What is the protocol for restoring this information? I've only done this before with the help of a representative and it was actual records rows that were deleted that I added back. This particular file didn't look like an easy fix. Pretty sure there is no backup either. I'm at a lost. Work can't move forward until we get the data back.

Any help is greatly appreciated!

Find more posts tagged with

Auditing

Accepted answers

S.Stone

@jgneely72151 were you able to determine when the information was last available? You should be able to pull a snapshot from the last time you know the data was correct and then add those rows back in.

I would start with the most reliable data for your first snapshot (ex., yesterday afternoon) and then spot check with the history in the activity to see if you need to pull any others to fill in the gaps. You should be able to see the specific changes through the Smartsheet Activity Log once you expand those sections.

I'm not sure how often the data changes, but we also utilize the weekly backups to keep records outside of Smartsheet. If you haven't set those up yet, I'd encourage you to consider it for extra protections.

I know it's not as easy as Ctrl+Z, but I hope it's helpful!

All comments

S.Stone

I know it's not as easy as Ctrl+Z, but I hope it's helpful!

jgneely72151

Thanks so much! Yes, the incident occured this morning and it is the snapshot with 1,415 cells changed. The data just looks a miss. I was trying to figure out do I have to organize the data on the snapshot for import or can I upload as is along with the comments. It's seem so overwhelming.

As far as backup, goodness, no, I don't believe we've even looked into that. Another thing to check out.

jgneely72151

Thanks for the tip! Because rows were not deleted, it was difficult trying to figure out how to import the data back in. It was just random cells missing data. Instead, I just went to each cell and cut/paste from the view cell history. it took some time but I got it done. I am now requesting that the team back up their work on a consistent basis so that we don't have these kinds of issues again.

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.