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'`