Total amount checked from all records

[smah17]

Hi everyone,

I’m working on a table where there are two checkbox fields (yes and no) for each record (employee). I would like to track the total number checked on each checkbox field from all the records. So the total amount of yes and no selected by the employees. There are 100 records (employees) in total. Does anyone have a way to achieve this?

Thanks for the help!

-S

[Hannah_Wiginton · Accepted solution]

Hey there!

Welcome to the Airtable forum!

What you need is a Summary Report.

• You’ll need to create another table in your base. You can call it Reports.

• You’ll then add a Linked record field to link it back to your Employees table.

• You’ll also need to add a Rollup field for the YES checkbox and a Rollup for the NO checkbox.

• The formula inside the Rollup field will be SUM(values)

• You’ll then add all your Employee records to a single record in your Reports table. It will automatically calculate the YES and NO totals.

Your Employee Table

Rollup Field for YES with SUM(values) formula

Reports Table

---

To understand what a Summary Report is and how to create one, here’s an article

On2Air | Airtable Apps for Your Business Operations – 28 Jul 22

How to Create a Summary Report in Airtable | On2Air

“How do I create a report in Airtable?” is one of the common questions we see from new (and even savvy) Airtable users. In this tutorial, you’ll learn how to create summary reports in Airtable, how automate record links to a report, and how to...

[smah17]

Thanks Hannah!

I got it working. I really appreciate the help!

[Hannah_Wiginton]

Awesome! Glad it worked for you!

If you have a minute, would you mind marking it as Solved so others can find a Solution if they need help with the same question?

Have a great day!