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
