Parent Row RYG Formula

System

This discussion was created from comments split from: Parent/Child row formula.

JuliaE

Can you help me with the formula for the parent row when using the symbols-Red, Yellow, Green? The priority would Red, Yellow, Green, such that if any child row is Red, the parent Row would be Red. The Parent Row would only be Green if all the child rows were Green. Thanks for your help!

Nick Korna

Hi @JuliaE ,

If you have child rows and a status column then the formula for the status on the parent row would be:

=IF(COUNTIF(CHILDREN(), "Red") >= 1, "Red", IF(COUNTIF(CHILDREN(), "Yellow") >= 1, "Yellow", "Green"))

Hope this helps!

JuliaE

Works perfectly! Thanks so much!!!