Applies to

  • Business
  • Enterprise


Who can use this capability

  • Owner
  • Admin


Standardize sheet summaries across sheets

Use batch copy to help keep sheet summaries consistent across up to 20 sheets.


  • Smartsheet
  • Business
  • Enterprise


  • Owner
  • Admin


Maintain consistency with your metadata and portfolio data by copying the sheet summary structure, formulas, and other content to up to 20 existing sheets at once.

Copy the sheet summary

In the sheet summary that contains the fields that you want to copy: 

  1. Select the menu icon Menu icon on the right side of the sheet summary.
  2. Select Copy summary to other sheets.
  3. Select up to 20 sheets to copy to. You can choose to copy only the field names or include any values and formulas in the fields.
Brandfolder Image
Copy Sheet Summary popup, where the user selects up to 20 sheets to copy the sheet summary to.
  1.  Select Copy.

Copying a sheet summary to other sheets is a permanent process, which you cannot undo. If there is a risk of overriding data, you'll see a prompt before beginning the batch copy process. 

Was this article helpful?