Formula to only count child where a specific value is in a multi-select drop down column
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:
- Formula to display the child teams on the parent line
- 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)))
Best Answer
-
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))
Answers
-
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.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
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))
-
Thanks @Paul Newcome - this worked perfectly.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!