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
- Click + New Formula.
- 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.
- Add the values the formula needs with + Add value. Each value gets a short name.
- Write the expression that combines them, for example
members * price - paid. - 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.
| From | Gives you |
|---|---|
| A form | A number calculated from that form’s entries |
| The entry being viewed | A field from the Detail Board’s entry (Detail Boards only) |
| A fixed number | A number you type, such as a price |
| Another formula | The 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) andsqrt. - The editor checks the expression and says Looks good. when it can be worked out.
Output
| Setting | Choices |
|---|---|
| Format | Number, Percent (adds %), or Duration (seconds shown as h m s) |
| Decimals | How many decimal places to show |
| Prefix / Suffix | Text 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.
Thanks for letting us know.
