RYGB formula that isn't working when Status is yellow (child row)
I have a sheet that has a column (Status) that is the RYGB symbols.
The Status key is:
Blue = Completed
Green = In Progress
Yellow = On Hold
Red = Not Started
There are two columns in the sheet:
Status (symbol column - RYGB)
Task/Description (Text/Number column) - each task has several subtasks (child rows)
I have the following formula in the Status column at the Parent row for each Task and then at the Parent row at the top of the sheet (line 1):
=IF(COUNT(CHILDREN()) > 0, IF(COUNTIFS(CHILDREN(), "Blue") = COUNT(CHILDREN()), "Blue", IF(COUNTIFS(CHILDREN(), "Yellow") = COUNT(CHILDREN()), "Yellow", IF(COUNTIFS(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", "Red"))))
We just update the child row RYGB ball to the appropriate color - no dates, % Complete etc.
However, it's not working correctly. Is the order of colors incorrect?
Any suggestions would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!