Formula columns
Create calculated columns that combine other columns with math, text, date and logic functions.
Watch this step in the video · Formulas
What a formula column is
A Formula column (ƒx) isn't typed in by hand: it's calculated from other columns on the board. For example, multiply {Quantity} × {Price} to get a total, count the days between two dates, or join text together. The result is read-only: it updates automatically whenever the cells it depends on change.
Use it for totals, margins, an item's age, calculated traffic lights, and any derived value you don't want to maintain by hand.
The formula column is a Premium feature: it shows a "Premium" badge in the picker and requires a plan that includes it.
Before you start
- You need a board with the source columns already created (the ones you'll reference in the formula).
- Your plan must include Premium columns. Check it under Plans & billing.
Create a formula column
- On the board, click + ("Add column") and choose Formula (search "formula" if you don't see it).
- The Formula editor opens with three areas: the expression, the column and function pickers, and a live preview.
- Type the expression in the text area. To insert a column, click it in the column panel: it's added as
{Column name}at the cursor. - To insert a function, open it in the function panel (grouped into math, text, date and logic) and click: it's inserted as
NAME()with the cursor inside the parentheses. Each function shows its syntax and description. - Pick the output type: Number, Text, Date or Boolean. This drives the formatting and which summary applies at the column's footer.
- Watch the preview: it computes the result against a sample item and, if the expression has an error, shows it in red.
- (Optional) Set a unit (e.g.
$,hrs) and decimals. - Click Save.
Quick examples
- Line total:
{Quantity} * {Price}→ Number output, unit$. - Days until due: a date function between today and
{Due date}. - Conditional label: a logic function returning
"Overdue"or"On time"→ Text output.
Verify it worked
- The preview shows a valid result (not an error).
- After saving, the column fills itself in across every row.
- Changing a source cell recalculates the formula's value.
If it doesn't work
- The preview shows an error: make sure the names in braces match the column title EXACTLY; if you renamed a column, insert it again.
- The result comes out as text when you expected a number: change the output type to Number.
- You can't find the Formula type: your plan doesn't include Premium columns; upgrade under Plans & billing.
- I can't edit the value in a cell: that's expected; formulas are read-only. To change the result, edit the source columns or the formula (header → Formula editor).
Tips
- Build the expression by clicking columns and functions rather than typing them: it avoids name typos.
- Keep one formula per goal; if you need two different calculations, create two formula columns.
Related articles
Related articles
-
Organize work with Projects & boards
Create boards with groups, tasks and subitems, use columns and Kanban or List views, link tasks to deals and contacts, and automate with recipes.
-
Projects (boards): complete guide
Projects in depth, in 54 chapters: boards, columns, formulas, Kanban, Calendar, Gantt and Workload views, forms, automations, My tasks and dashboard.
-
Column types in boards
Status, date, person, number, formula and more: build boards that fit your process.
-
Kanban and List views
See the same board as draggable columns or as an ordered list, depending on what you need.
-
Recipes (automations) inside boards
Create "when this happens, do that" rules so your board works on its own.