# Calculated fields and formulas

Use supported expressions and verify their results.

Audience: App creators

Reviewed: 2026-11-05

Canonical path: /docs/calculations

## What a formula does

A Calculated field derives a value from the record and supported functions. This is a product formula language, not a complete Excel engine. Use actual field names; display labels and workflow substitutions are separate concepts.

## Add and test

1. Choose a Calculated field in the table editor.
2. Enter an expression using record fields. Bracketed references make names explicit.
3. Save and inspect values on known sample records.
4. Test blanks, zeros and invalid values before relying on the result.

## Example

```text
ROUND([Quantity] * [UnitPrice], 2)

Quantity = 3 and UnitPrice = 12.50 should produce 37.50.
```

## Supported functions

- Numbers: ABS, ROUND, MIN, MAX and SUM.
- Conditional/blank checks: IF and ISBLANK.
- Dates: TODAY, NOW, DAYS, YEAR, MONTH and DAY.
- Text: LEN, UPPER, LOWER and TRIM.

## Important distinctions

A formula computes a value; a workflow performs an action. Workflow values such as {{CURRENT.Title}} use different syntax.

Do not assume SUM scans every row in a table or an unlisted Excel function is supported. Test representative values and investigate errors rather than replacing them with guessed totals.

## Related guides

- [Tables, fields and validation](/docs/tables-and-fields)
- [Lookups and linked tables](/docs/relationships)
- [Create workflows with AI or the editor](/docs/workflows)