Current Status Formula based on Hierachy
I am trying to use a formula to return my current status based on % completed and hierarchy only want level 1 task to know what phase ect. It keeps returning my level 0 and not my level 1 task name
what am i doing wrong?
In the Assigned to column i have the following formual
=INDEX([Task Name]:[Task Name], MATCH(MAX(COLLECT([% Complete]:[% Complete], [% Complete]:[% Complete], AND(@cell < 0.99, @cell > 0), hierarchy:hierarchy, (@cell = 1))), [% Complete]:[% Complete], 0))
In the hierarchy i have COUNT(ANCESTORS())
Help Article Resources
Check out the Formula Handbook template!