Multiple users in dropdown formula

Options

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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!