RYGB - need to update Parent row with status of children

Peggy Parchert
Peggy Parchert ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I am trying to get the Status in the Parent row to update automatically based off the Status of the child rows. I have the following formula in the Status column of the child rows:

=IF([Phase Status]@row = "complete", "Blue", IF([Phase Status]@row = "At Risk", "Red", IF([Phase Status]@row = "On Hold", "Yellow", IF([End Date]@row < TODAY(), IF([Phase Status]@row = "N/A", " ", "Red"), IF([Phase Status]@row = "In Progress", "Green", "")))))

That is working great!

But I can't get the Parent row to reflect the Status automatically. It should be show:

Red if any of the child rows are Red;

Yellow if any of the child rows are Yellow; 

Green if any of the child rows are Green;

Blue if all child rows are Blue;

I've attached a screenshot of my sheet. Any assistance would be greatly appreciated.

Screen Shot 2019-09-17 at 9.38.49 AM.png