Skip to main content

Column Totals/ Summary Footer

Show totals in the Grid View footer: counts and percentages for any field, sums and averages for numbers, ranges for dates.

Written by Emma Montgomery

Column totals sit in the footer of a Grid View and summarize the displayed records, with a footer for each group as well. Every field can show the count or percentage of empty or filled cells; number fields add sum, average, minimum, maximum, median, standard deviation and range; date fields show the earliest, latest or range.

Plan Availability

All plan types.

Permissions

Any member with access to the Grid View. The totals are saved with the view when autosave is on.

Platform

Web

Related Reading

How do I add a column total?

  1. In Grid View, hover over the footer under the column.

  2. Select the footer cell and pick a summary.

  3. The total appears in the footer. When the view is grouped, each group gets its own footer total.

A footer cell in Grid View being set to show a total.

Group footers in a grouped Grid View each showing a total.

Which summaries does each field type offer?

The options are named as the footer menu shows them. This table also covers what the Utilizing Column Totals in Grid View article listed; that article now points here.

Field type

Summaries

Every field (text, select, title and the rest)

Empty, Filled, % Empty, % Filled (the count or percentage of empty or filled cells).

Number fields (Number, Currency, Percent and similar)

Empty, Filled, % Empty, % Filled, Sum, Average, Lowest (minimum), Highest (maximum), Median, Standard Deviation, Range (lowest to highest).

Date fields

Empty, Filled, % Empty, % Filled, Earliest Date, Latest Date, Date Range (earliest to latest).

Status fields

A visual breakdown of the status values.

The summary options for a numeric column, including median, standard deviation and range.

The summary options for a date column, including earliest date and range.

Last verified 22 Oct 2026.

Did this answer your question?