Fields you can use in equations and formulas

Which field types a Text Formula, Number Formula, Date Formula, Equation, Rollup or Dynamic field can read, from its own table and from connected tables.

  • Verified Nov 17, 2026
  • Classic builder

On this page
  1. At a glance
  2. Field types by calculation
  3. When the field you need is missing

Each kind of calculated field only offers some field types when you build its formula. Use this page to pick the right calculation before you start, or to find out why a field is missing from the Add Field list.

At a glance #

CalculationReads fields fromGood for
Text FormulaThis table and connected tablesJoining text and values into one line
Number FormulaThis table and connected tablesAdding, subtracting, multiplying and dividing numbers
Date FormulaThis table and connected tablesTime between two dates, or a date plus or minus some time
EquationThis table onlyFunctions, IF logic, text and date functions
RollupThe connected records onlyCounting, totals, averages and lists across many connected records
DynamicThis table and connected tablesDisplay output worked out when the record is shown, not stored

Field types by calculation #

A field never appears in its own formula.

CalculationField types you can pickNot offered
Text FormulaText, Long Text, Rich Text, Email, Phone Number, Link, Number, Currency, Rating, Slider, Radio, Select, Checkbox, Multi-Select, Decision Box, Equation, Rollup, and the parts of Person Name and Address fields (for example Name - First Name or Address - City). The same types from connected tables.Date, Time, Date & Time, Date Range, Date Formula, Text Formula, Number Formula, File, Image, Signature and connection fields
Number FormulaThis table: Number, Currency, Slider, Auto Increment, Equation fields whose output is a number, Date Formula fields (as seconds, minutes, hours or days), and older Count, Maximum, Minimum, Average and Sum fields. Connected tables: Number, Currency, Number Formula and Equation fields whose output is a number. From both: Radio, Select, Checkbox and Multi-Select fields that store a number for each option (Score Value).Text and personal fields, dates, Rating, Rollup, other Number Formula fields in the same table, and everything else not listed
Date FormulaDate and Date & Time fields from this table and connected tables. Number fields from this table and connected tables, as an amount of time to add or subtract.Everything else, including Time, Date Range and Auto Increment
EquationEvery field in this table except the ones in the next column, including the record ID, Auto Increment, other calculated fields and the parts of Person Name, Address and Date Range fields.File, Attachments, Image, Signature, Checkbox, Multi-Select, connection fields, and any field from a connected table
RollupFields of the connected table. Count Records needs no field. Sum Value, Average Value, Minimum Value and Maximum Value are for number fields such as Number, Currency, Number Formula, Equation, Rollup, Rating and Slider; the list also offers date and time fields. Concatenate and Concatenate Unique take any field except Link.For Sum, Average, Minimum and Maximum: Text, Long Text, Rich Text, Email, Person Name, Radio, Select, Checkbox, Multi-Select, Decision Box, Text Formula, Link, File, Image, Signature and connection fields
DynamicFields of this table and of connected tables (listed as connection > field), and the parts of Person Name, Address and Date Range fields.File, Attachments, Image, Signature, Checkbox and Multi-Select

When the field you need is missing #

  • You need a date in a text value. Text Formula does not take date fields. Use an Equation instead.
  • You need another Number Formula from the same table. Number Formula fields cannot be nested. Repeat that formula inside parentheses in the new one, for example (Hours * Rate) + Trip Fee, or use an Equation.
  • You need a total of many connected records. A formula reads one connected record. Add a Rollup on this table first.
  • You need a connected value in an Equation. Equations only read fields of their own table. Use a Text Formula, Number Formula or Date Formula, which can read connected fields, or a Rollup.
  • An Equation field does not show as a number. Number Formula only lists Equation fields whose output type is a number.

Was this page helpful?

Something wrong or missing on this page? Tell us.