Parent Row RYG Formula

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


  • JuliaE
    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
    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
    JuliaE ✭✭✭

    Works perfectly! Thanks so much!!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!