Formula to only count child where a specific value is in a multi-select drop down column

Lisa McNeeley

I have a sheet with a parent child relationship with a Child Count column. The child lines will be assigned to different groups. I need the parent line to show on reports so I need the Team parent line to display all of the Teams listed on the child lines. I need help with two formulas:

1. Formula to display the child teams on the parent line
2. Formula to only count the child lines where a specific team appears. I tried the following but I get unparseable

=COUNTIF(AND(({HSI GSA Clause Child Count}, 0), ({HSI GSA Clause List Team}, CONTAINS([Primary Column]@row, @cell)))

Paul Newcome

For number 1 you are going to want something along the lines of...

=JOIN(CHILDREN(), CHAR(10))

and then enable text wrapping.

For number 2:

=COUNTIFS({HSI GSA Clause Child Count}, 0, {HSI GSA Clause List Team}, CONTAINS([Primary Column]@row, @cell))

Bassam Khalil

Hi @Lisa McNeeley

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Paul Newcome

For number 1 you are going to want something along the lines of...

=JOIN(CHILDREN(), CHAR(10))

and then enable text wrapping.

For number 2:

=COUNTIFS({HSI GSA Clause Child Count}, 0, {HSI GSA Clause List Team}, CONTAINS([Primary Column]@row, @cell))

Lisa McNeeley

Thanks @Paul Newcome - this worked perfectly.

Paul Newcome

Happy to help. 👍️