How do you archive Sheets without deleting them?

Rory Power

Hi,

 

I was hoping that I could get some information on how I archive sheets?

Adam Haylock

Not sure if there is a more sophisticated answer and any automation around this although is it as simple as simply moving into an archive folder.

Kennedy Stomps

Hi Rory-- There are a couple of approaches customers generally take in regards to retiring sheets they no longer use:

 

• Export or Backup your sheet, save it to a shared file server or cloud service like Box or Drive, then delete the sheet. This places the data into an Excel format, so you can access the data outside of Smartsheet or Import the data if needed later. The Backup also compresses the Attachments to allow you to download them locally and places Discussion info on the second page of the Excel workbook.

 

Alternatively, you could save your sheet as a Template which doesn’t go against a sheet count. Or, you could create a new sheet called Archive, put each sheet name on a row, create a backup (as in #1) of the sheet then attach the backups to rows on the Archive sheet so users can easily open the Excel file with the data. 

J. Craig Williams

Rory,

 

Here's an older thread on the subject:

https://community.smartsheet.com/discussion/how-do-i-archive-workspace-after-ive-completed-project

 

Since that thread was posted, I've pretty much migrated to a complete "Save As Template" methodology. For Reports, I take a screen shot of the Report Builder and store it for later if needed.

 

Also be aware that backing up to Excel is not a true backup - data is saved but not formulas or formatting.

 

Craig