Data Formulas

Updated November 9, 2026

Data Formulas calculate values from your entries, such as total raised, seats left or amount still owed, and let you show them in any text on the board. Set them up in Board Settings → Data Formulas.

The main board and each Detail Board keep their own list of formulas. Formulas on a Detail Board can also use the entry being viewed.

Create a formula

  1. Click + New Formula.
  2. Enter a Formula name, for example “Amount remaining”. The Token key is filled in for you; it’s the name you use to show the result.
  3. Add the values the formula needs with + Add value. Each value gets a short name.
  4. Write the expression that combines them, for example members * price - paid.
  5. Choose the output format and save the formula. Then save the board.

The Preview shows the result as you go, so you can check it before saving.

Values

Each value answers three questions: where it comes from, which entries it uses, and how they are calculated.

FromGives you
A formA number calculated from that form’s entries
The entry being viewedA field from the Detail Board’s entry (Detail Boards only)
A fixed numberA number you type, such as a price
Another formulaThe result of another formula in the same list

For a form, narrow the entries with Filter (only entries where…), or, on a Detail Board, use Related to take only entries linked to the entry being viewed, for example its volunteers. Tick Ignore the board’s active filter if the value should always use all entries.

Then choose how to Calculate: count, sum, average, smallest, largest, number of unique values, or the latest value.

Expressions

  • Use the value names with +, -, *, / and brackets.
  • Functions: round, floor (round down), ceil (round up), min (smaller of), max (larger of), abs (absolute value) and sqrt.
  • The editor checks the expression and says Looks good. when it can be worked out.

Output

SettingChoices
FormatNumber, Percent (adds %), or Duration (seconds shown as h m s)
DecimalsHow many decimal places to show
Prefix / SuffixText before or after the number, such as $ or /mo

Numbers use the board’s number format (thousands separator and decimal mark). See More board settings.

Show a formula

Use the formula’s tag in any text field on the board, such as a block title, a description or an HTML block:

{{formula:amount_remaining}}

Fields that accept tags have an insert button that lists your formulas, so you don’t need to type the tag.

Formula columns

List and Multi-Form List blocks can also add a formula column. It’s worked out for each row using that row’s own fields, for example {Total paid:5} - {Donation:7}. Sorting and CSV / Excel exports use the calculated number.

Looking things up in other entries for every row takes longer. Keep page sizes modest on lists that do this.

Was this page helpful?
Scroll to top