COUNTIF with HAS formula


I'm trying to use a COUNTIF formula with a HAS criteria, but it doesn't seem to be working for me. Would someone mind taking a look?

I'm trying to count the number of times "Apples" shows up in the multi-select column, Range A, while Range B also has "On Hold."

Here's the formula: =COUNTIFS({Range A}, HAS({Range A}, "Apples"), {Range B}, "On Hold")

Thank you.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!