Assistance needed to provide a status if children tasks are not complete and / or < 100 % complete
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"
Best Answer
-
=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
Answers
-
=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
-
@markkrebs I used =IF([% complete]@row = 0, "Not Started", IF([% complete]@row = 1, "Complete", "In Progress - On Track")) and it worked like I wanted it to, then as soon as I added another column "% Not Started" for the formula (=IF(COUNT(CHILDREN([Tasks Name]@row)) > 0, COUNTIFS(CHILDREN(Status@row), "Not Started") / COUNTIFS(CHILDREN(Status@row), <>"N/A"))) then the column you assisted me with stopped working. Do you know why there's a glitch? It only changes if I change any of the children tasks marked complete (not all complete). It use to change to "In Progress" when there was any task in progress. Let know if that makes sense.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!