Calculate columns in List and Table view

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

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:

  1. Hover over the column.
  2. Scroll down to the bottom of the column and click Calculate.
  3. Select one of the available calculation options.
  4. Click Calculate.

Tasks that are excluded due to a filter will not be included in the column calculation.

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.

Screenshot highlighting the individual column calculation and entire column calculation .png

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:

  1. Hover over the column.
  2. Scroll down to the bottom of the column and click the calculated amount.
  3. Click the delete icon.

 

Was this article helpful?