COUNTIFS Formula Help

Shelley Isbell

Hello,

I am trying to create a formula for my Dashboard Matrix. I need to count the Projects for Fofi Kantas listed as Project and Enhancement.

=COUNTIFS({Project Owner}, FIND("Fofi Kantas", @cell) > 0, {Type}, "Project")

I can count them for each but cannot figure out the formula for project or enhancement.

Nic Larsen

Try:

=COUNTIFS({Project Owner}, FIND("Fofi Kantas", @cell) > 0, {Type}, OR(@cell = "Project", @cell = "Enhancement")

jmyzk_cloudsmart_jp

Hi @Shelley Isbell

You can use OR or sum the two counts for Project and Enhancement.

If you want to use OR,

=COUNTIFS([Project Owner]:[Project Owner], HAS(@cell, Owner#), Type:Type, OR(@cell = "Project", @cell = "Enhancement"))

https://app.smartsheet.com/b/publish?EQBCT=1667947cb43a413f804b4e83077f51d0

or in your case

=COUNTIFS({Project Owner}, HAS(@cell, "Fofi Kantas"), {Type},OR(@cell = "Project", @cell = "Enhancement"))

Nic Larsen

Try:

=COUNTIFS({Project Owner}, FIND("Fofi Kantas", @cell) > 0, {Type}, OR(@cell = "Project", @cell = "Enhancement")

Shelley Isbell

Oh my gosh! Thank you that worked. I was putting the OR in the wrong place! YA

jmyzk_cloudsmart_jp

Hi @Shelley Isbell

You can use OR or sum the two counts for Project and Enhancement.

If you want to use OR,

=COUNTIFS([Project Owner]:[Project Owner], HAS(@cell, Owner#), Type:Type, OR(@cell = "Project", @cell = "Enhancement"))

https://app.smartsheet.com/b/publish?EQBCT=1667947cb43a413f804b4e83077f51d0

or in your case

=COUNTIFS({Project Owner}, HAS(@cell, "Fofi Kantas"), {Type},OR(@cell = "Project", @cell = "Enhancement"))

Shelley Isbell

Thank you so very much for responding so quickly.