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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!