Collect formula for child rows

Dhoke
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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    @Dhoke When you are referencing a column name that has spaces, numbers, and/or special characters, the column name has to be wrapped in [square brackets].


    =COUNTIF(DESCENADANTS([Report Status]@row), "In Progress")

    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!