Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Changing Parent to red, yellow, green based on child

Options

Hi, 

 

I'm trying to create a status report that will change the parent status to "Red" if one of the children are in "red", or yellow if the child milestone is in Yellow. These are milestones, so there should rarely be a red milestone and a yellow milestone at the same time, unless we're really off track. Can anyone help? 

 

Thank you

Comments

  • Brett Evans
    Brett Evans ✭✭✭✭✭✭
    Options

    Patricia,

     

    Putting this formula in your paren row RYG column will get youi there.

     

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

     

     

     

    I hope this helps.

    -Brett

    Capture.PNG

This discussion has been closed.