Left Arrow Icon
Blog

SmartSheet: How to Duplicate a Project

Account IconNathan Braun·2 min read·September 23th, 2024
Option 1: Save as Template
When to Use Save as Template
How to Use Save as Template
Important Options for Save as Template
Option 2: Save as New
When to Use Save as New
How to Use Save as New
Important Options for Save as New
Learn More About Duplicating Folders and Workspaces
Learn More About Duplicating Sheets
Additional Resources

There are two ways to duplicate a project in SmartSheet. The best method depends on what you want to copy, like sheets, reports, or dashboards.

The first option is Save as Template, which saves a sheet so you can copy it many times. The second option is Save as New, which lets you make a copy right away.

Option 1: Save as Template

When to Use Save as Template

Use Save as Template if you want to copy one sheet. You can also use Save as New for this, but if you want to copy more than one sheet, or copy a report, dashboard, folder, or workspace, you can't use Save as Template.

Save as Template is best when you have a main sheet that you plan to copy many times in the future, like every week, month, or quarter. It's also useful if you want to copy the same sheet for every new customer.

How to Use Save as Template

How to save a sheet as a template

  1. Click the Browse button in the left toolbar.
  2. Right-click the sheet that you want to save as a template.
  3. Click Save as Template.
  4. Click Data & Formatting Options to review the options.
  5. Click Save.

Important Options for Save as Template

Options for Save as Template

When using Save as Template, you can change options to control how the template works. You can choose whether to copy comments, attachments, cross-sheet references, sheet hyperlinks, filters, forms, and automation. Be sure to check these options before saving.

Option 2: Save as New

When to Use Save as New

Use Save as New if you want to copy more than just a sheet, like reports, dashboards, folders, or workspaces.

Save as New works with all SmartSheet items, while Save as Template only works for single sheets. If you need to copy multiple things, put them in a folder or workspace and then duplicate the whole folder or workspace.

How to Use Save as New

How to duplicate a sheet, report, dashboard, workspace, or folder

  1. Click the Browse button in the left toolbar.
  2. Right-click the items that you want to duplicate.
  3. Click Save as New.
  4. Click Data & Formatting Options and review the options.
  5. Click Save.

Important Options for Save as New

Options for Save as New

When using Save as New, you can change the options to control what data is copied, like comments, attachments, cross-sheet references, sheet hyperlinks, filters, forms, and automation. Be sure to review these options before saving.

Learn More About Duplicating Folders and Workspaces

To learn more about duplicating folders and workspaces, see How to Duplicate a Workspace or Folder.

Learn More About Duplicating Sheets

To learn more about duplicating sheets, see How to Copy a Sheet to a new Sheet and Can You Copy and Paste a Whole SmartSheet?.

Additional Resources