Formula Column
The Formula column type computes a value automatically based on other columns in the same row. Currently supports 4 functions.
Available functions
| Function | Syntax | Example | Result |
|---|---|---|---|
| Concatenate | concatenate(field1, " ", field2) | concatenate(first_name, " ", last_name) | "Jane Doe" |
| Lower | lower(field) | lower(email) | "jane@acme.com" |
| Upper | upper(field) | upper(status) | "ACTIVE" |
| Average | average(field1, field2, ...) | average(q1_score, q2_score, q3_score) | 85 |
Setting up
- Add a new column → select Formula
- Write the formula using column names as references
- The formula auto-calculates for every row
- Values update automatically when referenced columns change
Limitations
- Only 4 functions available (no SUM, COUNT, IF, DATE functions yet)
- No nested formulas (can't use a formula inside another formula)
- No cross-table references (formulas only reference columns in the same table)
Workarounds
For calculations beyond the 4 built-in functions:
- Rollup columns: aggregate values across linked records (SUM, COUNT, AVG, MIN, MAX)
- AI Column: use AI to compute complex derived values
- TinyWorkflows: trigger a workflow on row change and compute in the workflow, then write back
Note
The formula engine is actively being expanded. More functions (SUM, IF, DATE, etc.) are planned for future releases.