Formulas and parameters

Write quantity formulas with measurement tokens, waste factors, and math operators — and understand how parameters keep your budget in sync with the plan.

A parameter is a named value — usually a plan measurement — that you reference inside a quantity formula. Formulas let a line compute its own quantity instead of you retyping numbers.

Anatomy of a formula

A formula is plain math with measurement tokens mixed in:

  • {Wall Area} — a token, shown as a colored pill, that pulls in a measurement.
  • * 1.1 — multiply by a 10% waste factor.
  • ( … ) / 27 — group and convert (cubic feet to cubic yards).

So {Slab Area} * {Depth} / 27 reads as: slab area in square feet times depth in feet, converted to cubic yards.

Write a formula

  1. Double-click a line's Quantity Formula cell (a single click only selects it).
  2. Type or pick a measurement to insert it as a token.
  3. Add operators and numbers: +, -, *, /, and parentheses all work.
  4. Press Enter to commit, or Tab to move to the next field.
  5. Click Save changes to persist the budget's pending edits.

Note

Choose an existing parameter from the list, or type its name inside braces. Create a new reusable value in Parameters using Add Parameter; typing an unknown name does not create a takeoff.

Note

When two measurements share a name, both remain available. Pick the one under the correct plan/group instead of typing the ambiguous name. Its formula link stays with that measurement even if you rename it.

Manage project parameters

  1. On the budget toolbar, click Parameters.
  2. In Project, click Add Parameter, enter a name, and choose Value or Formula. Set its value or expression, format, and unit.
  3. Click Apply to put the edits into the budget's pending changes. Then save the budget to keep them. Undo and discard also include applied parameter edits.
  4. Use Takeoffs to inspect measured values; edit those values on the plans. The eye opens the measured page in a new tab.
  5. Use Assemblies & Rates for existing source values and Calculations to inspect available column formulas and an item's inputs.

Don’t see this?

Viewing Parameters requires budget access. Editing project inputs requires budget editing access. Financial values, team rates and plan links follow your existing permissions.

Common patterns

  • Waste factor{Roof Area} * 1.15 for 15% overage.
  • Unit conversion{Trench Volume} / 27 from cubic feet to cubic yards.
  • Coverage{Wall Area} / 350 for gallons of paint at 350 ft² per gallon.
  • Stacking({Floor 1 Area} + {Floor 2 Area}) * 1.05.

Unit Cost and Unit Price formulas

Quantity isn't the only field a formula can drive — Unit Cost and Unit Price can compute themselves too:

  • Unit Cost Formula — computes Unit Cost from org rates and takeoff variables, addressed by name; it can also reference {Quantity}. Setting one overrides the typed Unit Cost.
  • Unit Price Formula — sets Unit Price directly, for work quoted as a price rather than cost plus markup (for example 1.25 for $1.25/SF final wax). It can reference {Unit Cost}. Setting one makes both Margin % and Markup % calculated instead of editable.

Both columns are hidden by default. Turn them on for a view in View settings (click the eye beside each one); they sit immediately to the left of the number they produce. Double-click either one the same way you open Quantity Formula — type or pick a token, and the line recomputes whenever a referenced value changes.

Note

Your team's labor rates (for example Carpenter) are listed in the Unit Cost and Unit Price formula pickers as money per hour — $72.00/hr — not in the Quantity Formula picker, which offers measurements, project parameters and assembly quantities.

Note

A missing source or required input is not zero. Supply the input or choose an available source before relying on dependent quantities, costs, prices, or totals.

Why parameters beat typed numbers

A typed quantity is a snapshot — it goes stale the moment the plan changes. A parameter is a live link: re-measure on the plan, and every formula that references it recomputes, cascading through extended cost, price, and profit. Build the formula once and the math maintains itself.