Formula columns are a vital type of Custom Column. They let you define a formula that gets evaluated and returns a value. Formulas work similarly to how they work in other spreadsheet applications, but with a few differences:

  • You can only refer to other cells in the same row
  • Formulas are written in either Spreadsheet or JavaScript notation

You can add a formula column from the pipeline view. Clicking into the cell will open a larger textbox for you to write in.

When finished, use ⌘/Ctrl + Enter to save the formula.

Formula scoping

By default, the formulas in a column are the same for every Box in your Pipeline. You can customize formulas for each stage of the Pipeline, or even have a formula specific to one Box, too.

  • Entire Column (Default) – the formula will execute for every Box in the Pipeline
  • Just this stage – overrides a formula that is defined on the entire column. The formula will only execute for the Boxes that are in the particular stage.
  • Just this Box – overrides stage scoped formulas and column scoped formulas. The formula will only execute for this particular Box.

Referencing a column

To reference a column in a formula, the syntax is:

$'Column Name'

For example, a "Deal Size" formula column can be a product of two freeform columns:

= $'Number of Units' * $'Price per Unit'
Did this answer your question?