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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!