We are trying to create sheets to track the engineering, purchasing and production tasks required to build a large piece of industrial machinery in a small shop.
The may be 30 jobs in process at a time and each job may take several months to complete. Each job will have its own sheet and have up to 150 lines.
To schedule each job, so that it is completed on time, requires coordination of up to 10 people.
This means that each sheet represents many hours of discussions and coordination.
To lose a sheet or data on a sheet would have a fairly major impact and reduce the credibility of the system (and my credibility also).
I trust Smartsheet not to lose data and to have good backups for their own purposes.
My concern is that new users (or a user having a bad day) might make major, incorrect changes to a sheet that would take some time to recover from.
I am concerned that the normal backup just backups to an Excel spreadsheet and then not in a form that can be completely and easily restored without some work and maybe some confusion.
My back ground is in ERP/Database type systems where a restore would get you back exactly to the last backup if something bad happened, without having to do any work to reconstruct data.
It seems this could be achieved in Smartsheet by being able to schedule a Save as New on each sheet (with a time stamp in the saved sheet name) to be backed up. Of course the schedule would have to take into account the size of each sheet being backed up as well as how many backup versions were retained to manage space requirements. (Our data usage is low and disk space is cheap.)
There seem to be two other ways to achieve this.
1) The Backup Tool in Apps & Integrations, although that seems to involve a very complex technical project.
2) Services from the Smartsheet Backupify partner, although they seem to have been removed from the Apps & Integrations section as a partner.
I would appreciate any insights that anyone may have that would make me feel better about the possibility of losing data,
Thanks.