Sheet templates help you standardize your firm's methodology and provide a re-usable structure for engagements. Sheets created from a template copy all the columns, sections, views, and other data from the template.
Admins and users with permission manage sheet templates in Settings > Templates > Sheets.
Anyone with permission to create sheets can create from your firm's sheet templates.
Create a sheet template
Open the Sheet Templates menu and select ➕ Sheet Template.
Enter information for these fields:
Design your sheet template. You may include columns, sections, views, or other sheet elements.
Designing a sheet template
A sheet template may include columns, sections, views, rows, and other sheet elements. Only include elements that you expect to be reused across multiple engagements.
If you choose to include rows with pre-filled data in a sheet template, consider the following:
You can't link controls in the Control Activity column inside sheet templates. If you want to include controls in a template, consider adding them to a sheet inside an engagement template, instead.
You can import columns and rows to a sheet template from Excel.
Delete a sheet template
To delete a sheet template, follow these steps:
Open the Utilities menu inside the sheet template.
Select Delete sheet template.
Bulk insert a sheet template into engagements
Follow these steps to insert the same sheet template into multiple engagements at once.
In your sheet template, open Utilities and select Insert into engagements.
Select a location:
Sheets: Insert the sheet template into the Sheets menu in the selected engagement(s)
Documents: Insert the sheet template into the Documents menu in the selected engagement(s)
Use the check-boxes to select one or more engagements.
Click Insert.
Edit a sheet template
Once a sheet template is in use, most attributes can still be edited. You can apply these changes to active sheets using the Update active sheets menu.
Push template updates to active sheets
If you’ve modified a sheet template, you can update active sheets to include these changes.
Changes to column names don’t require pushing an update. To update to the latest column name, click the yellow dot 🟡 on the column header in the active sheet.
There are two ways to push template updates to sheets: update or overwrite.
If your sheet template contains a control activity column, contact [email protected] for help making changes.
Update existing sheet columns
The Update existing sheet columns option appends new columns and updates existing columns to reflect the current template. All existing cell data on the active sheet is preserved. This option works well for updating a sheet's methodology.
This option will not delete any existing data inside sheet cells, but it can change column names and other column configurations. This action can only be reversed by manually changing these settings back in the engagement's sheet.
This option will apply any updates to these settings to existing columns in the engagement sheet:
Name
Details
Type
If you change a column's type to a format incompatible with cells' current contents, their contents will not be lost. Those cells will display a warning.
Options
For example, the options available in a List type column.
Column-level client permissions
This will not make the overall sheet visible to clients, which must be set in an engagement sheet's settings.
Default order
If you want to change this at the template level, save the default column order on your sheet template before pushing the update.
Some edits to sheet templates can’t be pushed out to active sheets with this action, including:
New views
Deleted columns and sections
Sheet-level client permissions
Sheet description
Overwrite existing sheets
Overwrite existing sheets overwrites all data in the active sheet, including the sheet description.
This is a destructive action and should only be used if you want to replace the selected sheets entirely.





