Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Counting Check Boxes

Topic Labels: Formulas
Solved
Jump to Solution
1469 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.