Edit a column
Things to Consider
-
Required User Permissions:
-
'Admin' level permissions on the Company level Admin tool.
-
-
Additional Information:
-
You can only edit custom columns.
-
Custom columns display an Info (i) icon next to their name in the column list, whereas standard/locked columns display a Lock icon.
-
Steps
-
Navigate to the Company level Admin tool.
-
Under 'Tool settings', click Budget.
-
Select the Columns tab.
-
Locate your custom column using the Columns panel filters:
-
Search. Enter the column name in the search bar to filter columns by name.
-
Column type. Click on the drop-down list and select one or more column types.
-
Reportable column. Click to filter columns by one of the following options:
-
Yes. Select this option from the drop-down list to filter for columns included in the Single tool budget reports.
-
No. Select this option from the drop-down list to filter for columns excluded from the Single Tool budget report.
-
-
-
Click to select a custom column from the column list.
-
Update the column configurations as needed:
-
Calculated column. You can change the default column name, format, include column in single tool budget report, formula and display subtotals and grand total configurations.
-
Forecast to complete column. You can change the default column name, include column in single tool budget reports and formula configurations.
-
Source Column. You can change the default Column Name, Include column in Single Tool budget report, Data Source and other advanced configurations as available for the selection.
-
-
(Optional) Review dependencies under the details panel:
-
Views associated. Click the caret
icon to see all Budget or forecasting views using this column. Click any hyperlink view name to navigate to it. -
Columns associated. Click the caret
icon to view calculated columns that incorporate this column into their formula.
-
-
Save your changes:
-
Click Save to update the existing column.
-
Click Save as new column to duplicate your update as a new column while preserving the original column.
-

