validate_formula
Parse-check a formula expression server-side without writing anything. Returns { ok, error?, rewrittenFormula?, referencedFunctions, unknownFunctions }. Use BEFORE update_row / create_row when the formula references functions or syntax you're not 100% sure of: a =SUMIFS(...) with the wrong arg order or a misspelled =AVERAG(...) will round-trip into the cell as a stored carrier with no value, and the user will see #NAME? or #VALUE? on next view. Catch it here. unknownFunctions flags any identifier that isn't in the Dock Sheets catalog (including likely typos); referencedFunctions lists the canonical post-alias names the engine will see. Cheap, public, no auth, no workspace context needed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| formula | Yes | Formula expression to validate, including the leading '='. Example: '=SUMIF(B2:B10, ">0")'. Max 4000 chars. |