COUNTIF with HAS Formula in Sheet Summary


I am trying to do a COUNTIF in the Sheet Summary for a column that is a Multi Select Dropdown. I know that you are supposed to use the HAS function, but I can only seem to get that to work in the sheet with @Cell. Any suggestions?

=COUNTIF([Department of Concern]:[Department of Concern], HAS([Department of Concern]:[Department of Concern], "PCC"))

The formula gives me an answer of 0 but there are several cells that have PCC selected.

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Julie Tausch

    Are you receiving a specific error when you use @cell? If so, is it possible that the syntax isn't quite right?

    @cell will need to be typed fully in lower-case in order for it to be recognized, but it should work in a Sheet Summary Field:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!