Parent RYG(B) status balls automated based on Child status
I have been scanning the community and have found some bits for what I am trying to do but am struggling to put it altogether and was wondering if anyone could help?
I have a list of tasks with headers (parents) which then have sub tasks (children) and some of them also have sub tasks (children again i believe). The first thing I wanted to do was for the Parent status to update based on the Child statues. I did so with this formula:
=IF(COUNTIF(CHILDREN(), "Red") = COUNT(CHILDREN()), "Red", IF(COUNTIF(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", "Yellow"))
What i want to do is take it a step further and say, if all Children are Blue (complete) then change the parent status to Blue also, but if not, follow the above formula.
I tried nesting this into the start of the above formula, but im just getting INVALID:
Any ideas much appreciated?
Help Article Resources
Check out the Formula Handbook template!