All column typesBack to all column types
Column type
StandardNumber
A Number column stores numeric values that can be sorted, compared, and used in formulas and rollups. Use it wherever a value needs math: hours, counts, points, or thresholds.
In one line
Numeric values: counts, hours, quantities, and scores used in math.
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
Hours, quantities, headcounts, and capacities.
Points and scores that workflows compare against thresholds.
Inputs to formulas and targets for rollups.
Examples
Real columns built with this type
Attendance points
UsersCompared against tier thresholds by workflows.
Openings
JobsHow many workers a job order needs.
Good to know
Use Currency instead of Number for money so formatting and reporting stay correct.
Thresholds in workflows read numbers reliably — keep the unit consistent across records.