CONTAINS COUNTIFS from Multi-Select Drop-Down

RingJake ✭✭✭✭✭
edited 06/22/22 in Formulas and Functions


I've had this issue before, but forget how I've solved it. I have a formula that is trying to count an option in a multi-select menu, it cannot be a simply COUNTIFS statement and must use CONTAINS or HAS since there is more text in the cell then just one word.

Here is my formula, which is appears the syntax is correct, but it is not counting. Can somebody please let me know where I've gone wrong? Thank you!

=COUNTIFS({NPI Impediments}, CONTAINS([Schedule Change]$1, {NPI Impediments}), {Project}, $[Domain For Impediment]6)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!