Using countif for multi-select dropdown + parent/children rows

Hello,

Hope you can help me. I want to count how often "PROSPEC" (multi-select drop-down) is selected in the column "Dokumentation" when the parent column "Fase" is equal to "Pilot" or "Drift" (single-select drop-down). Please see image below.

My formular so far: =COUNTIFS(Dokumentation2:Dokumentation194; HAS(@cell; "PROSPEC"); Fase2:Fase194; OR(@cell = "Pilot"; @cell = "Drift"))

It will allways return "0" because it does not take the "children/parent" into account.

Hope it makes sense. Thank you in advance.

Anne


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!