COUNTIFS/HAS $ dropdown with multiple selections possible in a cell

Options

Looked up suggestions/solutions in the community.

This formaula, I would have thought, would have worked:

=COUNTIFS(Facility:Facility, HAS(@cell = "CRMH", Status:Status, <>"Green")) + " Project(s) at ACME ROADRUNNER"

Unfortunately it returns a value of "0". Should be "4".

Thanks in advance for any help.

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hey @DanielGD

    The syntax above is not quite what smartsheet is expecting. Try this

    =COUNTIFS(Facility:Facility, HAS(@cell, "CRMH"), Status:Status, <>"Green") + " Project(s) at ACME ROADRUNNER"

    Will this work for you?

    Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!