Urgent help please! How to restore a sheet exactly as it was?

Question

Hello! I need urgent help please!

Is it possible, either locally on Smartsheet or with a third party platform, to restore a past version of a sheet to an identical format? I have tried the local Smartsheet backup, ProBackup, and am troubleshooting Fluentpro Backup. All have trouble with parent child cell relationships, conditional formatting and formula restoration. I rely on these functions for my sheets and need to know if there is a way to restore/recover a past sheet to exactly what it was?

Please send any recommendations for upgrades, third party apps, or tips. Ideally I would just click 'restore' and the past sheet would upload to Smartsheet with out the need to manually update conditional formatting, indent cells, or add formulas back in. I want something that requires minimal steps please.

An example of an app where this works well is in Google Docs; you can see version history and then restore to a past version exactly as it was. If there is anything that will do that for Smartsheet please let me know.

Thank you!

smartorange_2 · Answer

I see. Thank you for your help.

Is there a way to request that Smartsheet make this kind of restore possible? I

Naeem Ejaz · Answer

You’ll need to:

* Save as new
* Replace the old sheet manually (rename/move/share)

This is currently the closest thing to a true “restore button.”

smartorange_2 · Answer

Hello! I meant to say 'formulas'; is it possible to restore formulas such as

=SUM(CHILDREN())

Thank you!