Get startedCLIAPIMCPWebDesktopAgentsSupportBillingChangelog
← All changelog
May 13, 2026

Formulas in tables. 39 functions.

SUM, IF, SUMIF, INDEX, MATCH, TEXT, TODAY, ISNUMBER, the full set. A1 cell references, error treatment in plain language, live recompute when any source cell changes. The autocomplete glows the letters you've already typed so you always know what you'll get.

Formulas in tables. 39 functions.
New
  • 39 functions across six categories: Math (SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, ROUND, ABS, MOD, POWER, SQRT, COUNTIF, SUMIF, AVERAGEIF), Logic (IF, AND, OR, IFERROR, IFS, SWITCH), Text (CONCAT, TEXT, LEN, LEFT, RIGHT, MID, TRIM, UPPER, LOWER), Date (TODAY, NOW, DAYS), Lookup (INDEX, MATCH), Predicates (ISBLANK, ISNUMBER, ISTEXT, ISLOGICAL, ISERROR, ISNA).
  • A1 cell references, ranges (A1:A10), whole-column refs (A:A), absolute refs ($A$1). Live recompute when any source cell changes.
  • Formula bar above the sheet shows the formula text + computed value side-by-side. Click a cell to inspect, click the `fx` chip to open the function picker for discovery.
  • Autocomplete dropdown opens on `=`. Typed-prefix glows in the function's category color so a half-typed `=SU` makes it obvious which `SUMIF` you'd land on. The dropdown is Apple-Spotlight glass, the row hover is the org-switcher's accent-tinted recipe.
Polish
  • Mobile gets a full-screen function picker reachable from the cell editor. Grouped by category, with the same signatures and examples the desktop autocomplete shows.
  • Errors render as plain-language sentences. `#DIV/0!` in the cell, `"Dividing by zero. Check the cell on the right of the /."` in the hover tooltip and formula bar.
  • Complete reference page at [/docs/web/formulas](/docs/web/formulas) covering A1 addressing, every function with examples, error treatment, persistence model, and scripting access.