Red/Yellow/Green/Blue Status Indicators

Dawn_Cox

I'm new to both PM and smartsheet.

I set up the RYGB Status ball indicators for my (first!) project. I had help in creating a formula that would automatically update the indicators on the parent rows based on the children rows. The formula isn't working as I wanted.

I wanted if all the children are red, the parent is red.

If all the children are blue, the parent is blue.

If the children are all yellow, the parent is yellow.

Otherwise, the parent is green.

This is the formula I have. It works if all the children are red, or if there is a mix of status. If the children are all Blue the parent changes to Yellow (not Blue).

Can someone help me edit this formula, please?

=IF(COUNTIF(CHILDREN(), "Red") = COUNT(CHILDREN()), "Red", IF(COUNTIF(CHILDREN(), "Blue") = COUNT(CHILDREN()), "Yellow", "Green"))

Paul Newcome

Try this:

=IF(COUNTIFS(CHILDREN(), @cell = "Red") = COUNT(CHILDREN()), "Red", IF(COUNTIFS(CHILDREN(), @cell = "Blue") = COUNT(CHILDREN()), "Blue", IF(COUNTIFS(CHILDREN(), @cell = "Yellow") = COUNT(CHILDREN()), "Yellow", "Green")))

Paul Newcome

Try this:

=IF(COUNTIFS(CHILDREN(), @cell = "Red") = COUNT(CHILDREN()), "Red", IF(COUNTIFS(CHILDREN(), @cell = "Blue") = COUNT(CHILDREN()), "Blue", IF(COUNTIFS(CHILDREN(), @cell = "Yellow") = COUNT(CHILDREN()), "Yellow", "Green")))