Formula fields

Tenant-authored computed fields with a deterministic AST.

Overview

Create read-only computed fields on tasks / projects / goals using the same FormulaNode AST that powers Views v2 conditional formatting. Example: days until due, overdue+HIGH flag, estimate + recurrence score.

Highlights

AST nodes: literal, field, compare, logical, not, between, dateDiffDays, match
Zod-validated on write - malformed payloads can never reach the evaluator
/formula-fields/:id/evaluate runs the formula over a batch of rows in one call

Important to know

Formulas are pure - no side effects, no external calls.
Evaluation is O(rows × ast-size). Batch the call for large corpora.

How to use it

POST /formula-fields with scope + name + AST.
POST /formula-fields/:id/evaluate with a rows[] array to compute.
Reference in Views v2 as a grouping or formatting key (future batch).

Atlas docs · Atlas - the AI-native work platform