Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

Any licensed users with access to the sheet can copy a sheet as new.
 

Copy a sheet with save as new

When you copy a sheet with save as new, columns and conditional formatting rules from the original sheet will always be saved to the new copy.

PLANS

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions

Any licensed users with access to the sheet can copy a sheet as new.
 

Create a copy of a sheet

  1. Select FileSave as New to display the Save as New window.
  2. Type a name for the new sheet.
  3. Under Save in, select the folder or workspace where you’d like to save the copied sheet.
  4. Select to show the options for Notifications & Sharing Options and Data & Formatting Options and choose which items you want to save with the copy of your sheet.
  5. Choose Save.

Save as options

  • Sharing: Preserves any sheet sharing that you've set up. 
  • Automated Workflow & Alert Options: Retains any associated Automation rules with the saved copy of the sheet. 
  • Workflow recipients and Automation Permission Settings: Retains permission settings for the rules. 
    • If a rule for the new sheet has no valid recipients (that is, if no one will be able to receive notifications based either on the permission settings or on the approved domain sharing list for the account) the sheet owner will receive this message in email: An Automation rule on your sheet has become invalid. This sheet’s permissions settings are currently preventing recipients from getting notifications.
    • To modify rule permission settings for the sheet:
    1. Click Automation > Manage Workflows... on the menu bar​​​​
    2. In the Automation window, click the Settings Settings icon icon in the upper-right to modify permission levels.
  • Sheet data and formatting: Includes information typed into cells and formatting manually applied to them. If unchecked, copied sheets will retain column names and types but all rows are blank.
  • Comments: Includes all row and sheet-level comments.
  • Attachments: Includes all row and sheet-level attachments.
  • Cell links: Preserves inbound cell links only. If unchecked, the sheet copy retains the cell data but does not create any links. 
  • Sheet hyperlinks: Maintains hyperlinks to other sheets. If you don't check it, the sheet copy will retain the cell data, but won't hyperlink.
  • Sheet filters: Includes sheet filters.
  • Forms: Includes any forms that you add to the sheet.
Was this article helpful?
YesNo