COUNTIF vs COUNTIF HAS

Options

I have the simple COUNTIF formula in a roll up sheet but am struggling with the formula picking up a single entry from a multiple dropdown selection:

The simple count if formula that is working is:

=COUNTIF({Sprint Tracker Range 5}, "Subject")

The more complex COUNTIF with HAS I have created is that is not working is:

=COUNTIF({Sprint Tracker Range 5}, HAS({Sprint Tracker Range 5}, "Subject"))

The problem is the HAS formula is pulling the wrong total of appearances (pulling zero).

Any advice is greatly appreciated.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!