Help

Total amount checked from all records

Solved
Jump to Solution
277 3
cancel
Showing results for 
Search instead for 
Did you mean: 
smah17
4 - Data Explorer
4 - Data Explorer

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!

yesnototal

-S

1 Solution

Accepted Solutions
Hannah_Wiginton
10 - Mercury
10 - Mercury

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
2022-08-09_10h31_35

Rollup Field for YES with SUM(values) formula

2022-08-09_10h34_40

Reports Table
2022-08-09_10h31_41


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

______________________________________
Hannah - On2Air.com - Apps for Airtable - Dashboards, Forms, Backups, and Documents

See Solution in Thread

3 Replies 3
Hannah_Wiginton
10 - Mercury
10 - Mercury

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
2022-08-09_10h31_35

Rollup Field for YES with SUM(values) formula

2022-08-09_10h34_40

Reports Table
2022-08-09_10h31_41


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

______________________________________
Hannah - On2Air.com - Apps for Airtable - Dashboards, Forms, Backups, and Documents

Thanks 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!

______________________________________
Hannah - On2Air.com - Apps for Airtable - Dashboards, Forms, Backups, and Documents