Standard column type
Number
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.
Illustrative example
Numeric values: counts, hours, quantities, and scores used in math.
- 01
Table
Users
- 02
Field
Attendance points
- 03
Purpose
Compared against tier thresholds by workflows.
A suggested way to organize your information. This diagram is not a product screen.
When to use this type
- 1Hours, quantities, headcounts, and capacities.
- 2Points and scores that workflows compare against thresholds.
- 3Inputs to formulas and targets for rollups.
Column ideas for your team
Users
Attendance points
Compared against tier thresholds by workflows.
Jobs
Openings
How many workers a job order needs.
Good to know
- 1Use Currency instead of Number for money so formatting and reporting stay correct.
- 2Thresholds in workflows read numbers reliably; keep the unit consistent across records.