Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Counting Check Boxes

Topic Labels: Formulas
Solved
Jump to Solution
2709 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarah_Brewster
4 - Data Explorer
4 - Data Explorer

I have a spreadsheet that I am using to keep track of when a document is returned. The primary field is the person’s name, then there is a column to record a specific program that person is in (set as a single select), then the next column has a check box. The check box will be selected when the person returns their document.

I’d like to record how many people return their documents by Program. So how many people in Program A have returned their documents, Program B, and so forth. Is there a formula to create this?

Ideally, I’d have a second table that has the Program name in the first column and then the total in the second column. Essentially, a countif formula.

1 Solution

Accepted Solutions
JonathanBowen
13 - Mars
13 - Mars

Hi @Sarah_Brewster - you’re on the right lines. Better to make the programs have their own table (rather than a single select):

Screenshot 2020-01-30 at 16.50.00

Then link each person to a program:

Screenshot 2020-01-30 at 16.50.32

with a checkbox against the person to show if they have returned the document.

You can then rollup this checkbox field on the program table:

Screenshot 2020-01-30 at 16.51.35

JB

See Solution in Thread

2 Replies 2
JonathanBowen
13 - Mars
13 - Mars

Hi @Sarah_Brewster - you’re on the right lines. Better to make the programs have their own table (rather than a single select):

Screenshot 2020-01-30 at 16.50.00

Then link each person to a program:

Screenshot 2020-01-30 at 16.50.32

with a checkbox against the person to show if they have returned the document.

You can then rollup this checkbox field on the program table:

Screenshot 2020-01-30 at 16.51.35

JB

Thank you so much! This is very helpful.