What is the best way to count a range of cells part of a hierarchy that meet a specific criteria?

I am trying to wright a formula using the descendants function and I am sure at this point I am over complicating a rather simple process but need some assistance to see past my own frustrations.

In the picture below, the Blue row is the parent row. I need to count the descendants for that parent that meet the criteria of "Completed".

This is the direction I have been working and have been able to parse the data yet: =COUNTIFS(Status@row:Status@row, "Completed", DESCENDANTS([Task Name]5))

Any assistance would be greatly appreciated.

Thank you


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!