Calculate column data in List and Table view!
Whether you're tracking profit and loss, actual versus estimated time, or labor costs, the flexibility of column calculations keeps important data readily available.
Feature availability and limits vary by plan and user role. Learn more
Calculation types
There are several calculation options that vary by field type:
- Count
- Count values
- Count unique values
- Count empty
- Percent
- Percent empty
- Percent not empty
- Dates
- Range
- Earliest date
- Latest date
- Numerical
- Sum
- Average
- Range
- Min
- Max
- Median
Field types
You can calculate most standard fields and Custom Fields.
Some fields are only displayed when their associated ClickApp is activated.
| Field type | Calculation options |
| Assignee | Count Percent |
| Checkbox Custom Field | Count Percent |
| Date Custom Field | Count Percent Dates |
| Dropdown Custom Field | Count Percent |
| Email Custom Field | Count Percent |
| Files Custom Field | Count Percent Numerical |
| Formula Custom Field | Count Percent Numerical The Formula must have an output before you can calculate the column. |
| Labels Custom Field | Count Percent |
| Location Custom Field | Count Percent |
| Money Custom Field | Count Percent Numerical |
| Number Custom Field | Count Percent Numerical |
| People Custom Field | Count Percent |
| Phone Custom Field | Count Percent |
| Progress (Manual) Custom Field | Count Percent Numerical |
| Rating Custom Field | Count Percent Numerical |
| Relationships Custom Field | Count Percent Numerical |
| Signature Custom Field | Count Percent |
| Text Custom Field | Count Percent |
| Text area (Long Text) Custom Field | Count Percent |
| Voting Custom Field | Count Percent Numerical |
| Website Custom Field | Count Percent |
| Due date | Count Percent Dates |
| Priority | Count Percent |
| Status | Count Percent |
| Task ID | Count Percent |
| Date created | Count Percent Dates |
| Date done | Count Percent Dates |
| Date updated | Count Percent Dates |
| Start date | Count Percent Dates |
| Time tracked | Count Percent Numerical |
| Time estimate | Count Percent Numerical |
| Sprint points | Count Percent Numerical |
| Date closed | Count Percent Dates |
| Created by | Count Percent |
| Comments | Count Percent Numerical |
| Assigned comments | Count Percent Numerical |
| Linked tasks | Count Percent Numerical |
| Dependencies | Count Percent Numerical |
| Linked Docs | Count Percent Numerical |
Calculate columns
To calculate a column in List or Table view:
- Hover over the column.
- If you don't see the column, add it to your view.
- Scroll down to the bottom of the column and click Calculate.
- Select one of the available calculation options.
- Click Calculate.
Tasks that are excluded due to a filter will not be included in the column calculation.
Time estimates and time tracked that rollup from subtasks to parent tasks are always included in column calculations. This includes estimates and time tracked from closed subtasks, even when closed subtasks are not displayed in your List or Table view.
After calculating a column in List view, you'll see results for each group in your view, as well as a calculation for the entire column when you click on the calculated amount.
Remove column calculations
If you no longer want to see a column calculation in List or Table view, you can remove it.
To remove a column calculation:
- Hover over the column.
- If you don't see the column, add it to your view.
- Scroll down to the bottom of the column and click the calculated amount.
- Click the delete icon.