← Help center · Sheets & views

Formula fields

Updated Oct 24, 2026

A Formula field calculates its value from other fields. You never type into it; it recalculates whenever its inputs change.

The field picker, with Formula in the Sheet Inter Connect group
The field picker, with Formula in the Sheet Inter Connect group

Add one

  1. Add a field and choose Formula.
  2. Build the expression — click a column to insert a reference to it.
  3. Save. Every existing record fills in immediately.

Arithmetic and text

Combine fields with sum, subtract, multiply and divide, and join text with concat. Quantity × unit price, revenue − cost, first name joined to last name.

Date functions

FunctionWhat it returnsExample
days_from(Date Field)Days elapsed since that date until todaydays_from(Start Date) → 12
days_to(Date Field)Days remaining from today to that datedays_to(Due Date) → 5
days_between(Start, End)Days between two date fieldsdays_between(Start Date, End Date) → 30

There are also start day of and end day of for a date range, and progress days percent for how far through a period you are — useful for a project that should be tracking to a schedule.

Rounding

round(Number Field) rounds to the nearest integer. round(Price) → 42.

Functions across child rows

When a record has subtasks, these summarise them without any manual maintenance:

FunctionWhat it returns
sum_children()Total of a numeric value across all child rows
avg_children()Average across child rows
min_children()Smallest value among child rows
max_children()Largest value among child rows

So a parent project can total its subtasks' estimates automatically.

Testing where a record sits in a hierarchy

hasParent() returns true when the record is a subtask; hasChildren() returns true when it has subtasks. Both are useful for filtering — showing only top-level work, for example.

Using the result

A formula field behaves like any other field once calculated: filter on it, sort by it, group by it, chart it. A days_to(Due Date) formula plus a sort is a countdown that maintains itself.

Notes

  • Formula fields are read-only — that is the point.
  • To have an ordinary field fill itself from a formula, so people can still change the value, use the field's Fill setting instead: see Fill a field automatically.
  • A formula reads fields on its own record (plus the child functions above). To summarise linked records from another sheet, use a Rollup.
  • Rename a field a formula depends on and check the formula still resolves.

Related: Relations, mirrors and rollups · Subtasks and dependencies · Build a sheet with custom fields

Related articles

How to preview a file without downloading it
Click a file in a File List field to see it in the file viewer: photos, PDFs, video, audio, Word files, spreadsheets and more, with no download.
How to close a form on a date or after enough responses
Set an Atwork form to stop taking responses at the end of a day you pick or after a set number, and take one response per person, block spam or get emails.
How to pin up to four fields under a row's title
Pin a status, due date, owner or budget under a row's title in Atwork. Up to four short fields, the same on every row for everyone who opens the sheet.