Tables & field types — Formula fields: compute a value from an expression (3)

Formulas are checked as you type — an unknown field name gets an immediate "did you mean" suggestion, and a problem is reported with the exact spot in the expression, not just a generic error. Typing { opens field suggestions (keep typing to filter, dots walk through links), and typing a function name offers completions with their signatures — Enter or Tab accepts. Prefer plain English? Describe what you want in the ✨ Or describe it box — "profit margin as a percent" — and press Write it for me. The formula is generated and validated against your real schema before it lands in the box, so it can never hand you something that doesn't compile. It counts as one AI action. Unlike Lookup and Rollup, a formula's expression can be edited any time from its row in the field list — there's no need to delete and recreate it.