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.
What you'll need
- Workspaces on the Unlimited Plan and above can calculate columns.
- Everyone, including guests, can calculate columns.
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 both standard fields and Custom Fields.
Some fields are only displayed when their associated ClickApp is enabled.
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.
After calculating a column, 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.