Who can use this capability
Owners and sheet Admins (who also have a license) on both the source and destination sheets can batch copy sheet summary structures.
Batch Copy to Standardize Sheet Summaries Across Sheets
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 you want to copy:
- Click the menu icon on the right side of the sheet summary.
- Select Copy summary to other sheets.
- 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.
- Click Copy.
Copying sheet summary to other sheets is a permanent process and cannot be undone. You'll receive a prompt before beginning the batch copy process if data could potentially be overridden.
That’s it! Your sheet summary has been copied.