Get startedCLIAPIMCPWebDesktopAgentsSupportBillingChangelog
← All changelog
May 15, 2026

Formulas, now in REST, MCP, and CLI.

The function catalog, formula validation, and one-shot evaluation are accessible from every agent surface. Same engine the table UI runs, same answers. Discover what exists, parse-check before you write, compute against real workspace data, all from agent code.

Formulas, now in REST, MCP, and CLI.
API
  • `GET /api/sheets/functions` returns the 39-function catalog with category, slice, signature, and worked examples. Public, no auth. Filter by `category`, `slice`, or substring `name`.
  • `POST /api/sheets/validate-formula` parse-checks a formula and reports referenced + unknown function names. Catches `=SUMI(...)` before you persist a stale carrier.
  • `POST /api/sheets/evaluate-formula` computes a formula. Standalone (no workspace) for `=SUM(1, 2, 3)` style sanity checks; pass `workspaceSlug` to evaluate against actual rows + columns.
  • Three matching MCP tools: `list_sheet_functions`, `validate_formula`, `evaluate_formula`. Mirrors the REST surface 1:1. Tool count bumped to 47.
  • Matching CLI commands: `dock sheets functions`, `dock sheets validate`, `dock sheets eval`. CLI v0.9.0 on npm.