Collect formula for child rows

Dhoke ✭✭✭
edited 08/15/23 in Formulas and Functions

I am trying to return the sum of "in process" items under each parent row in the following sheet but can't come up with the right formula/syntax to work. I got a formula to correctly return teh number of child rows but now need the number of items "in process" per parent row and the following formula gives me UNPARSEABLE error. I thought a COLLECT formula would work but I can't figure it out.

COUNTIF(DESCENADANTS(report status@row), "In Progress"))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!