Formula Field

A formula field is a column in a no-code database (Airtable, Notion, SmartSuite, and similar) whose value is computed automatically from other fields in the same record, rather than typed in by hand. Like a spreadsheet formula, it recalculates whenever its inputs change. Examples: `Price * Quantity` for a line total, `DATETIME_DIFF(Due, TODAY(), 'days')` for days-until-due, or concatenating first and last name into a display name. Why it matters: formula fields keep derived data correct and consistent without manual updates or a separate automation — the database itself does the math. They're the backbone of no-code dashboards, status indicators, and conditional coloring. Practical note: formula fields are read-only (you can't edit the result directly, only the inputs), and each platform has its own function syntax and quirks — Airtable and Notion formulas are not interchangeable. Heavy formulas across thousands of records can slow a base, and formulas that reference linked records often need a rollup or lookup field to pull the other record's value in first.