Comment on page
This section is intended as a general reference and specification set. If you are new to SmartBackup, you will need to use the full documentation.
Since its first release SmartBackup is positioned as one of the leading backup solutions for Smartsheet. There are different editions of the product, depending on your needs, with differing capabilities as outlined further in this Reference Guide.
SmartBackup is offered in three Editions, one free and two commercial editions to accommodate the unique feature and price requirements of organizations and individuals.
- 1.Starter Edition is the free edition that includes most capabilities to help you get started.
- 2.Business Edition delivers fully featured backup capabilities for individuals and small teams.
- 3.Enterprise Edition is ideal for situations requiring centralized control, larger scale deployments and enterprise flexibility.
You can download from AcuWorkflow. This completely free version allows you to try the solution without any obligations. The great thing about the Starter Edition is that there is no time limit so you can experience it for as long as you like. Bearing in mind that it is the most basic version and it has built in limitations such as the maximum number of Sheets that it will backup up.
You can purchase this directly from the AcuWorkflow web site. This version is packed with features and should cater for most of the situations you encounter as an individual or small team of up to 5 Users.
The SmartBackup Platform primarily consist of the following components, which can be run independently or in conjunction.
Make an exact copy, preserving your formats, links, rules, attachments, a feature not available from standard Smartsheet backups.
Drain your Backup Pool automatically to a file-store residing outside Smartsheet.
On-demand or scheduled securing of all or individual sheets to a file-store residing outside Smartsheet. Ideal for DRP.
Table with latest stable release features are shown. Terms and conditions apply.
Use Limits and Restrictions:
Backup refers to the copying of a Smartsheet object from your Home/Workspace/Folder to a designated Workspace within Smartsheet called the Backup Vault so that it may be used to restore the original in the event of data loss or data corruption.
- 3.Folders (Reports)
Due to Smartsheet API constraints, backup of all Smartsheet objects in a consistent way is not possible.
Sheets and Dashboards are handled in the same way and can be backed up incrementally. Reports are not 'copy-able' nor contain a last-changed date and therefore can only be backed up via a folder arrangement. This way Reports or anything else included in designated folders can be earmarked for backup. The latter can only be performed via the "Specific" Backup option.
SmartBackup will automatically determine which Sheets or Dashboards to backup in ALL or INCREMENTAL mode. INCREMENTAL is based on the last modification date for every sheet or dashboard you own. By default a backup run will include all sheets modified in the last
5days and up to 100 of the most recently changed Dashboards. This Incremental period can be adjusted based on your needs. Refer to the Administrator Guide for details.
In SPECIFIC mode you need to tell SmartBackup which sheets, dashboards or folders to include in the Backup run.
The scope of sheets changed within the
5day period (or period chosen) will determine the actual number of sheets backed-up.
To exclude certain sheets from being backed-up one can rename those Sheets starting with
zz2.For example, if you have a sheet called “Campaign Plan”, then simply rename that sheet to “
zz2.Campaign Plan”, and then it will not be included in future backups.
All sheets backed up will be an exact copy of the original including the following:
** The SmartBackup Administrator can turn these options ON or OFF by editing the
config.ymlfile. NOTE: Cell history is not backed-up.
NOTE: If Smartsheet Legacy Resource Management is enabled in a source Sheet, resource allocations in all backup copies of that Sheet will be included in the Legacy Resource Management reports. This will result in invalid resource utilization data. Instead, if you need a robust resource management solution then consider using Resource Management by Smartsheet.
The backup sheet is the same format as the original Sheet, and it is saved in the User's Smartsheet environment.
For every Backup run, a folder named
zz2.YYYY_MM_DD_HHMM_useridwill be created within the designated Backup Vault (Smartsheet Workspace) and all the sheets and dashboards meeting the backup criteria for a particular User will be saved within that "Vault" workspace.
Sheets and Dashboards in the Vault will be prefixed with an id of
zz2.followed by the original name. The reason for renaming this way is so that they can be recognized as backup copies and to help with identifying the backup copies when searching for Sheets and Dashboards. This also allows SmartBackup to identify the backup copies so that it does not create backups of the backup copies.
The SmartBackup Administrator can optionally decide to add the SheetID to the backup copy name, therefore it becomes
zz2.1234567890123456.nameby turning on addsheetid. NOTE: The name will be truncated to fit into the Smartsheet max size of 50 characters.
The following optional parameters can be supplied when you invoke Backup.
These optional parameters may be combined together.
backup.exe -d=3 -i=incremental -q=FinDeptwill find all sheets and dashboards that have changed in the last 3 days and where the User is assigned to a Queue called "FinDept" and will create backup copies of those assets and save them to the User's vault workspace.
For Logging, a rotational Log file called Backup_log
x.log will be created in the ..\data directory with timestamped entries. If you encounter an error, you can review this log file for error details.
Archive refers to the archiving (copying or moving) of a backed up sheet from your Vault to a designated local drive. Optionally, the SmartBackup Admin can specify that the Vaulted (backup copy) be removed during this process by setting the flag. See Administrator Guide Settings for details.
SmartBackup will automatically determine which sheets to archive. It is based on the last backup date for every sheet in the Vault. By default, an archive run will archive all sheets that were backed-up more than 5 days ago. This period can be adjusted based on your needs.
The scope of sheets changed within the
5day period (or period chosen) will determine the actual number of sheets archived.
All sheets archived are different to the original format. Mainly due to the fact that it is re-instantiated outside the Smartsheet environment as an Excel file. Therefore most Smartsheet features cannot be archived, in part due to Excel incompatibilities and what is available in the Smartsheet API.
Consider these Archived copies as a "third level" backup copy that contains the minimum amount of data for backed-up sheets.