Assistance needed to provide a status if children tasks are not complete and / or < 100 % complete

Denera McCullough

I've tried several formulas and often receive back unparseable, blocked, incorrect, or circular

I need assistance with the parent tasks. For example, Where it says "Not Yet Started" and "In Progress - On Track" parent tasks I want the formula to indicate if all children tasks status = complete then mark parent complete, if children task = 0 % complete then status is "Not Started", if children task < 1 % complete then status is "In Progress - On Track"

markkrebs

=IF([% complete Helper]@row = 0, "NOT YET Started", IF([% complete Helper]@row = 1, "Complete", "In Progress"))

Helper column: % complete Helper

=IF(Children@row > 0, AVG(CHILDREN()), [% complete]@row)

Note: you only need to input the % complete on the bottom rows and make the % column a % format