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
Best answer by Hannah_Wiginton
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
+18Hey 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
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
Thanks Hannah!
I got it working. I really appreciate the help!
+18Thanks Hannah!
I got it working. I really appreciate the help!
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
