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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!