Reports let you summarize data in a sheet via counts, sums, averages, etc. They are similar to pivot tables in spreadsheets, or aggregates in a SQL database.

Creating a report based on a group column

To create a report with a single group column—such as Status, Owner, Industry, Role, etc.—go to the column you want to group on and choose the report option in the column menu:

This will start you with a count report; see below for how to add other formulas from there.

Creating a simple summary report

To create a simple count, sum, etc. over the whole sheet, not broken out by any column, click in the search bar and choose “summary functions”:

Then choose a function for a single-number report, or choose “report” to combine multiple functions in one view:

Adding formula columns to a report

To add more formulas to a report, just add a column. This will automatically prompt you for a formula.

Adding group columns to a report

To add or change the grouping for a report, edit the group term in the search bar directly. The fields listed here will be used to create the report.

Reports update automatically

A report isn't a static snapshot of the underlying data. It updates automatically whenever the sheet is changed.

Did this answer your question?