Formula columns

Create calculated columns that combine other columns with math, text, date and logic functions.

Jun 26, 2026

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

  1. On the board, click + ("Add column") and choose Formula (search "formula" if you don't see it).
  2. The Formula editor opens with three areas: the expression, the column and function pickers, and a live preview.
  3. 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.
  4. 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.
  5. Pick the output type: Number, Text, Date or Boolean. This drives the formatting and which summary applies at the column's footer.
  6. Watch the preview: it computes the result against a sample item and, if the expression has an error, shows it in red.
  7. (Optional) Set a unit (e.g. $, hrs) and decimals.
  8. 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

Was this helpful?

Related articles

Message us on WhatsApp