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

Patricia Thurston
Patricia Thurston ✭
edited 12/09/19 in Archived 2017 Posts

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

· Share on FacebookShare on Twitter

Comments

  • Brett Evans
    Brett Evans ✭✭✭✭✭✭

    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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories