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))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks @Paul Newcome - this worked perfectly.
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!