Multiple users in dropdown formula


I'm trying to countifs a user is on target. My sheet column is a multiple selection column, some rows have multiple users selected. When I create my formula, it doesn't count if said user is sharing a responsibility with someone else. Here is my current formula =COUNTIFS({2021-2022 COMPLIANCE WORK PLAN Person Responsible}, "JS", {2021-2022 COMPLIANCE WORK PLAN Status}, "On Target").

This user also shares a responsibility with someone else, she should show 5 on target, the formula only shows 4 since 1 tasks is shared with someone else.

Also, once I get this working how do I set it up on the dashboard so they can click on their name and show just their tasks?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!