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

• Reach straight through a link — no Lookup field required first: {Company.Region} follows the Company relation field and reads Region off the linked record. Chain it as many hops deep as the schema allows: {Company.Region.Manager}. And there's no syntax to memorise — in the Insert a field list, click the › beside a link field to browse the linked table and insert the whole reference with one click. • Use functions across text, math, dates, and logic — ROUND(...), IF(...), CONCAT(...), DATEDIF(...), and more. The Function reference in the Add field panel lists every one with its exact usage. • Combine with a Rollup for totals across a to-many relation — a formula can reference an existing Rollup field by name ({Total Line Items}) alongside its own math, but can't aggregate a to-many relation directly; that's still what Rollup is for. It also works the other way round: a Rollup can total a Formula, so an order total can sum a calculated line total sitting on each line — whatever that formula is built from, including one that reaches through a link or reads the line's own Rollup.