Disaster Recovery / Version Control
What are people doing for disaster recovery and version control with the sheets and data?
Currently we have scheduled backups on all our workspaces. The completed emails get forwarded to a zapier zap that pulls the zip file and uploads it to Google Drive.
For mission critical sheets we have Data Shuttles make csv files of the sheet every hour and push them out to Google Drive.
But that only covers the contents of the sheets. Not the formulas, reports, etc. What are people doing to not loose all of that?
I've taken a quick look at the API, and it appears that if I asked for a list of all the sheets and then walked through that list and asked for all the sheet data I get a json file that contains all the contents including the formulas. This looks like the same format I could feed to the API create sheet function.
So in a disaster I could take the json files and walk through them to re-create the sheets?
Has anyone done this? Any other ideas?
Thanks.
/marc
Answers
-
Hi @marc4
It sounds like you have a good set-up so far. What I would personally suggest in regards to Formulas, Reports, and Dashboards is to use the Save as New function to create an archive copy of your Workspace or Folders.
See: Backup best practices and Copy a folder or workspace
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives