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

DanielGD

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.

Kelly Moore

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

Kelly Moore

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

DanielGD

Kelly,

Thanks!! It works! (missing comma...)