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

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?