Copying a workspace or folder is much easier than recreating a set of sheets for a new project or client, and it also saves time. You can copy any folder or workspace that contains up to 100 items.
USM Content
Create a copy of a folder or workspace
- On the left navigation bar, select Browse.
- Go to the item you want to copy.
- In the left panel, right-click the name of a workspace or folder.
- Select Save as New...
When copying a folder, use the Save in field to select the workspace where you want to store the copied folder. When copying a workspace, you always create a new workspace and can name it.
- Enter a name for the new workspace or folder.
You can set a new name for the workspace or folder copy, but the names of any sheets, reports, and templates contained continue to match the originals. You can rename them after you make your copies.
- Expand the following sections and review whether you want to keep the items described in each section:
- Sharing
- Automated Workflow & Alert Options
- Data & Formatting Options
- Choose whether you want reports, dashboards, sheet links, and cell links to refer to either of these options:
- Newly created sheets: This option remaps links to reference the newly created copies when copying interlinked items within the same folder or workspace.
Links to items outside the copied folder or workspace remain linked to the outside item, and you may need to remove them manually. - Original sheets: Newly created items continue to link to the same sheet as the original item.
- Newly created sheets: This option remaps links to reference the newly created copies when copying interlinked items within the same folder or workspace.
- Select OK.
Find your new workspace by going to Home > All workspaces.
What happens when you copy a folder or workspace
The new copy always saves the following from the original:
- The subfolder structure
- Sheets
- Columns
- Conditional formatting rules
- Templates
- Reports
If you have a Move or Copy Row automation workflow on a copied sheet, the Move or Copy Row action targets the original destination sheet of the workflow, not the newly copied destination.
After copying the folder or workspace, you must update your Move and Copy Row automations with the new target sheet.
Choose which data and formatting to keep in the copy
Here’s more information to help you:
- Sheet data and formatting: Include information typed into cells and formatting manually applied to them. Otherwise, copied sheets retain column names and types, but all rows appear blank.
- Comments: Include all row, sheet, and workspace (if you’re copying a workspace) comments.
- Attachments: Include all row, sheet, and workspace (if you’re copying a workspace) attachments.
- Cell links and cross-sheet references: Preserve cell links. If you don’t select this option, the cell data stays in the sheet copy but isn't linked.
- Sheet hyperlinks: Maintain hyperlinks to other sheets. If you don’t select this option, the cell data stays in the sheet copy but isn't hyperlinked.
- Shared sheet filters: Retain filters you created for the sheet.
- Forms: Include any forms in the sheets.
- Workspace branding (workspace copy only): The copied workspace inherits the same colors and logo as the original. If you don’t select this option, the new workspace inherits the colors and logo set up on your Smartsheet account.
When you copy a workspace or a folder with a report
The new copy of the report copies the criteria set in the following report tabs of the original report:
- Source Sheets
- Columns to Display
- Filter Criteria
- Group
- Summarize
- Sort