Skip to main content

Calculations in table views

Add a calculation to the bottom of a table column to count records, sum numbers, or see how many are complete.

Written by Leo

A table calculation summarizes the values of one column in a cell at the bottom of the table. It's meant to help you see totals and counts without building a report.

You can use table calculations for many things, including:

  • Summing the monthly rent of all properties in a view.

  • Counting how many tasks are not complete yet.

The bottom row of a table with Sum under the Amount column and the calculation menu open

Note:

  • Available calculations depend on the field. A number can be summed, a text can only be counted.

  • Only table views have calculations. Boards and lists don't.

Who can use table calculations?

  • Table calculations are available on all plans: Free, Plus, and Premium.

  • Everyone who can open the table can add calculations. They're part of the view settings, so to save them in a team view, you need Full access or Can share. Learn more about saving views →

Add a calculation

  1. Open a table view.

  2. Scroll to the bottom of the column you want to summarize. The cell reads Calculate. Under the first column it's always visible; under the other columns, it shows when you hover over the bottom row.

  3. Select the cell and choose a calculation.

Selecting Calculate under the Amount column and choosing Sum

To remove a calculation, select the cell again and choose None.

On a phone, the table shows the calculations that are already set, but you can't add or change them.

Calculations you can choose

Every field type has these calculations:

  • Count all: the number of records.

  • Count not empty and Count empty: how many records have or don't have a value.

  • Percent not empty and Percent empty: the same as a share of all records.

The calculations of a status field, including Count complete and Count incomplete

More are offered for these fields:

  • Number fields, and Calculation fields that return a number: Sum, Average, Median, Minimum, and Maximum.

  • Status and Task list fields: Count complete and Count incomplete.

FAQs

Can I sum a Calculation field?

Yes, if the field returns a number. Fields that return text or dates only offer counts. Learn more about the calculation field →

Do calculations count records I filtered out?

No. Calculations only include the records that match the filters and the search of the view, and that you're allowed to see.

Can I add a calculation to every column?

Yes. Each column has its own Calculate cell.

Can I add a calculation on my phone?

No. On a phone, you can see the calculations of a table view, but you can't add or change them. Use Tape on a computer instead.

Can I use calculations in a board or list?

No. Calculations are only available in table views.

Where can I find an overview of views?

In Views, filters, sorts & groups →. It explains Table, Board, and List layouts, team and private views, and how filters, sorts, and groups fit in.

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?