Calculate columns in List and Table views

  • Updated

Paid Workspaces can calculate numeric fields in List view and Table view to find their sum, average, or range! 

What you'll need

  • Workspaces on the Unlimited Plan and above can calculate columns.

  • Everyone, including guests, can calculate columns.

Calculate columns

To calculate a column:

  1. In any List or Table view, click the + icon to show existing columns or add additional columns.

  2. Hover over any numeric column to reveal the Calculate button at the bottom of it.

  3. Select Sum, Average, or Range.

  4. Click Calculate.

Screenshot of the add column button and calculate option in List view

This will work for both standard fields as well as numeric Custom Fields that you create.

Once you add a calculation, you'll see results for each group in your List view, as well as a calculation for the entire column. Table views will show a calculation for the entire column.

Screenshot of total estimated time in column calculations

Calculate an entire column

Eliminate task grouping to see one calculation for your entire column:

  1. Click on a column header in a List or Table view to open the column settings menu. 

  2. Select Sort entire column to remove any grouping applied to the List view and sort tasks by the selected field.

    Screenshot showing the 'sort entire column' option in List view.
  3. Select Sum, Average, or Range.

  4. Click Calculate.

Was this article helpful?