Undo question

Hello,

I was editing a formula and somehow the whole sheet appeared with the error #INVALID OPERATION. I was trying to undo the last change to reverse it, but the button wouldn't appear enable and the sheet was saved! I invested a lot of time ==(. Is there anyway to recover the previous version of my sheet?

Thank you.

Find more posts tagged with

Sheets

API and Developers

Formulas

Support

Solution Center

Comments

Andrée Starå

Hi Silvia,

I would contact the Smartsheet team directly for this.

Would that work for you?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

J. Craig Williams

Once the Sheet is Saved, the history is deleted (there is no undo).

Craig

Senando Benig Jr

Hi Silva,

I think the best way to recover your data is to correct the formula you edited previously, since the data was link to each other it affects all.

Thanks

sen

Richard Rymill SBP

Silvia

Might just be worth using Cell History to take your changes back to the original content if that was working at that point?

It may take longer asking Support but they definitely have the capability to give you what you seek but it may take a day or so, they are very busy!

Good luck with that!

Another suggestion to stop this happening again....

In your personal settings you can set the amount of delay on Autosave. I have mine for 1 Minute and save when I close or leave a sheet.

However there are times when planning or demonstrating scenarious where this is to short so reset it to longer so you can demo the rewind button!

eg demo a Gantt Chart with two potential kick off dates and show how this impacts the Finish date. the use the rewind to show the difference.

Then put your settings back at the end!

Hope that Helps

RichardR

J. Craig Williams

As Richard says, Cell History might help.

MIGHT.

Cell history from the UI only shows the DISPLAYED VALUE. What you likely want is the ACTUAL VALUE (if the problem was a mistyped formula)

Senando's suggestion to just figure out which formula went wrong is probably the most likely route to success.

Smartsheet does not have intermediary save points, that is, between the times the Save button is used, in their servers. Or if they do, then I'm very surprised. I believe those 'undo points' are stored locally, as they should be. This saves on processing power, both locally and on the server side. In my opinion this is an improvement over the way some other cloud based sharing system function.

Craig

Silvia C Rodriguez

Thank you all for your help. All of your comments are helpful. As a newbie I learned my lesson. Always back up! lol

Thank you again.

Silvia

Andrée Starå

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.