Child Parent code for schedule not working
I have reviewed the formula helper and used their code and change it up a bit but not working as it should, when I change to blocked or on Hold the Parent is not changing, here is the code
=IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(), "Blocked") > 0, "Blocked", IF(COUNTIF(CHILDREN(), "On Hold") > 0, "On Hold", "Not Started"))))
I need it to do the following
If all children are complete than it should be complete
if any of the children are In progress it should be in progress
if any of the children are on hold it should be on hold
if any of the children are blocked it should be blocked.
If all of the children are not started it should be not started
Caroline
Best Answer
-
Nested IF formulas read from left to right and stop on the first true value. So if you have In Progress in one child row and On Hold in another child row, it will register a true value with the In Progress argument, output that, then stop evaluating. If you want On Hold to "override" In Progress, you would need to adjust the order in which your IFs are nested.
Answers
-
Nested IF formulas read from left to right and stop on the first true value. So if you have In Progress in one child row and On Hold in another child row, it will register a true value with the In Progress argument, output that, then stop evaluating. If you want On Hold to "override" In Progress, you would need to adjust the order in which your IFs are nested.
-
Thank you! that worked.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!