Count Checks on Another Sheet
I need a formula that matches a user's name on the first sheet and goes to a second sheet to find that same user's name and counts how many times that user has a checkbox checked off.
I tried something like this but am getting #NO MATCH as a result.
=INDEX(({Target Sheet with Username Column Selected}), MATCH([Username Column]@row, COUNT({Target Sheet with Checkbox Column}, 1)))
Any thoughts on why this won't work if the checkbox is checked?
Judy
Answers
-
Try using a COUNTIFS instead.
-
I replaced "COUNT" with "COUNTIFS" and "COUNTIF" and neither produced the number.
-
Can you paste in the COUNTIFS that you used?
-
=INDEX(({Live Lesson Reviews (Quality Assurance) Range TN}), MATCH([Active Teachers]@row, COUNTIF({Live Lesson Reviews (Quality Assurance) Range SE}, 1)))
Live Lesson Reviews (Quality Assurance) Range TN = Name of column on other sheet looking at the Teacher's Name
Active Teachers = Teacher's Name on the sheet where I want the count to appear
Live Lesson Reviews (Quality Assurance) Range SE = Name of column on the other sheet looking at the checkbox for Sent Email
-
You would have to use a standalone COUNTIFS. Not have it nested inside of another function.
-
Here's an example of what @Paul Newcome means, if it helps!
=COUNTIFS({Teacher Column}, [Active Teachers]@row, {Checkbox Column}, 1)
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!