Advanced column type
Formula
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.
Illustrative example
A computed value calculated from other columns on the same record.
- 01
Table
Shifts
- 02
Field
Hours
- 03
Purpose
End time minus start time, used by payroll views.
A suggested way to organize your information. This diagram is not a product screen.
When to use this type
- 1Shift duration from start and end times.
- 2Total cost from hours and rate.
- 3Derived flags such as expiring within 30 days.
Column ideas for your team
Shifts
Hours
End time minus start time, used by payroll views.
Documents
Days to expiration
Feeds compliance tabs and reminders.
Good to know
- 1Formulas recalculate automatically; never store a derived value in a manual column.
- 2Keep formulas readable; a formula no one understands becomes a bug no one finds.