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.

Calculate columns

To calculate a column in List or Table view:

1. Hover over the column.
   • If you don't see the column, add it to your view.
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, 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:

1. Hover over the column.
   • If you don't see the column, add it to your view.
2. Scroll down to the bottom of the column and click the calculated amount.
3. Click the delete icon.