All column typesBack to all column types
Column type
AdvancedFormula
A Formula column calculates its value from other columns on the record. Use it for derived values that should stay consistent instead of being retyped: durations, totals, composed labels, and derived states.
In one line
A computed value calculated from other columns on the same record.
Where you see this
In the column type picker when adding a column to any table. Types are grouped as Standard, Premium, and Advanced.
Use it for
Where this type fits
Shift duration from start and end times.
Total cost from hours and rate.
Derived flags such as expiring within 30 days.
Examples
Real columns built with this type
Hours
ShiftsEnd time minus start time, used by payroll views.
Days to expiration
DocumentsFeeds compliance tabs and reminders.
Good to know
Formulas recalculate automatically — never store a derived value in a manual column.
Keep formulas readable; a formula no one understands becomes a bug no one finds.