Admins can restrict column management in a sheet template to prevent Firm Members and client users from removing them or modifying their metadata in downstream sheets. Restricting column management doesn't prevent users from editing cell contents—it only prevents them from changing the column itself.
Restricting sheet column management only restricts editing on columns that originate from a sheet template. They don't restrict users from creating new columns or from editing manually-created columns inside an engagement's sheet.
Who is affected
User | Effect |
Firm Members | Cannot remove or change the configuration of columns that came from the sheet template. They can still edit cell contents, and can still add new columns if they have Sheets edit access. |
Client users | The same, on sheets that are shared with clients. |
Firm Admins, System Admins and Engagement Admins | Not affected. They can manage every column as normal, whether or not the restriction is on. |
To restrict column management, follow these steps:
Open the ☰ menu inside the sheet template.
Select Restrict Column Management.
This setting applies automatically to any sheets created from the template.
To re-enable column management, open the same menu and select Allow Column Management.
If you cannot change a column in a sheet
If the options in a column’s menu are unavailable and you are a Firm Member or a client user, column management is probably restricted on the sheet template that column came from. You have a few options:
Ask a Firm Admin at your firm to make the change for you.
Ask a Firm Admin to select Allow Column Management on the sheet template, if the restriction is no longer needed.
Add a new column instead, if you have Sheets edit access. The restriction only applies to columns that came from the template.
Renaming a column in a sheet does not change the matching column heading in a generated report. See Add a report table from a sheet for how to update the report heading.

