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:

  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)))

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!