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
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!