evaluate_formula
Evaluate a formula expression against an actual Dock workspace's columns + rows, server-side, returning the same display value the UI's HyperFormula engine would render. Two modes: STANDALONE (omit workspace_slug) — evaluates against an empty grid; useful for =SUM(1, 2, 3) or any formula with no cell references. IN-WORKSPACE (pass workspace_slug, optionally at) — loads the workspace's grid, evaluates the formula as if pasted into the at cell (or A1 if omitted), resolves real refs against actual data. Returns { ok, displayValue, error? }. Workspace mode requires read access; standalone mode is public.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| at | No | Optional anchor cell (only used with workspace_slug). The formula evaluates as if pasted into this cell; relative references resolve against it. Omit to anchor at the workspace's first cell. | |
| formula | Yes | Formula expression including '='. Max 4000 chars. | |
| workspace_slug | No | Optional workspace slug. Pass to evaluate against the workspace's actual rows + columns. Accepts bare or org-prefixed form. |