Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How can I archive sheets that I no longer use?
My team has a bunch of sheets that we do not use but we might need to reference later. Whats the best method for archiving sheets we are not using so they do not clutter up our accounts or count towards our sheet count but with the ability to access them as needed?
Comments
-
Here is a great blog post from the Smartsheet team on methods to archive sheets: http://www.smartsheet.com/blog/tips-support-don%E2%80%99t-delete-archive-your-sheet
Hope this helps!
-
I routinely use Export to Excel to save sheets that I might want to refer to in the future without keeping them active and thus counting against the number of sheets I have. After exporting the sheet I can delete it or in some cases I reuse it after deleting the original data. Exports to Excel typically do not export formulas that were in the Smartsheet so you can't Import the sheet back into Smartsheet and have a working sheet again. It is possible to export the formulas by having one of the Smartsheet support people enable that on your system but that also enables it on reports which typically messes up the calculations on rows that end up in the report. I also have Smartsheet do an automatic backup download every Saturday. The backed-up sheets do not have the formulas either, just the values in each cell.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives