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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!