Countifs formula using CONTAINS


Hi all,

I am currently working on a cross-sheet formula that is trying to determine how many projects are listed as a specific health for a specific person listed in a multi-select drop down. I have been able to determine how to get this formula to work, but only for cells that have one person listed.

=COUNTIFS({Overall Project Health}, "Yellow", {Assigned To}, "Bob Jones")

If there is another person listed in the Assigned To field with Bob, the formula will not count that project. I think I need to add CONTAINS into this formula, but am struggling with how to make it work.

Any help is appreciated.



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!