Skip to main content

Sheet templates

Create sheet templates and add sheet templates to engagements

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

  1. Open the Sheet Templates menu and select ➕ Sheet Template.
    ​

  2. Enter information for these fields:

    • Name

    • Framework (optional)

    • Type
      ​

  3. 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:

  1. Open the Utilities menu inside the sheet template.

  2. 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.

  1. In your sheet template, open Utilities and select Insert into engagements.

  2. 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)

  3. Use the check-boxes to select one or more engagements.
    ​

  4. 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

  • Default order

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.

Did this answer your question?