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.

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.

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.

   

3. Select Sum, Average, or Range.

4. Click Calculate.

Updated May 09, 2023 00:38