ForemanFOREMAN

Custom budget columns

Show, hide, reorder, and rename budget columns, and add your own manual or formula columns across every budget in your organization.

The budget sheet has a lot of built-in columns, and you can tailor which ones show, what order they're in, and add your own. Column settings apply to every budget in your organization, so the sheet looks the same on every project.

Show, hide, reorder, and rename columns

  1. Open the budget (Projects → a project → the Budget tab).
  2. In the toolbar, click Column visibility.
  3. In the Column visibility panel:
    • Click the eye on any column to show or hide it.
    • Drag a column by its handle to reorder it.
    • Click a column's name to rename it.
  4. Click Save.

Note

You can also drag a column header directly on the sheet to reorder it — the panel is the fuller editor for show/hide and rename.

Add a custom column

  1. In the toolbar, click Add column.
  2. In Add column, set:
    • Name and an optional Description (the description shows in the column's ? tooltip).
    • Type — Text, Long text, Whole number, Decimal, Currency, Percent, Toggle, or Dropdown.
    • Band — which color-coded group it belongs to (Details, Estimating, Costing, Invoicing, or Profit).
  3. For a numeric type, you can add a Formula — leave it blank for a column you fill in by hand, or write an expression to compute it per line.
  4. Click Add column.

Formula columns

A formula column computes its value per line from other columns and your project's measurements:

  • Reference other columns by their id — for example extPrice - committedCost, or committedCost / extPrice * 100.
  • The picker below the formula box lists every variable you can use; start typing to filter it.
  • Project measurements from your takeoff are available too, so a formula like unitCost * {Sqft} works.

To remove a custom column later, open Column visibility and click the delete icon on that column's row.

Don’t see this?

Column tools appear in the toolbar only when your role can edit the budget. If the toolbar has no Column visibility or Add column buttons, ask your organization owner for budget editing access.