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
- Choose a Calculated field in the table editor.
- Enter an expression using record fields. Bracketed references make names explicit.
- Save and inspect values on known sample records.
- Test blanks, zeros and invalid values before relying on the result.
Example
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.