Parent row inheriting status from its children

MattH42 · 08/15/17

Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summation of the child rows. E.g. if the child rows are red, green, and green, the parent row would show red. E.g. if the child row is yellow, green, and green, the parent row would be yellow.

(I'd probably want to do this similar logic with columns using other symbols, as well. For example, when I have columns that are priority or flagged)

Richard Rymill SBP · 08/16/17

Matt

Take a look at this help page, i think you will find what you seek there.

https://help.smartsheet.com/functions

RichardR

MattH42 · 08/16/17

The documentation on the different functions is pretty weak on actionable examples. But it was a good start and I found the following achieves the necessary logic:

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

MaiyaD · 07/23/19

Hi MattH42,

I was wondering if you can help me with the following?

I am looking to populate the status of parent row to symbol: Red, Green, Yellow

Parent Row:

Red Symbol = If ALL child rows are red symbols

Yellow Symbol = If ONE of child row is yellow or all child rows yellow (child row may contain red)

Green Symbol - If ALL child rows are green

Thanks in advance!

Andrée Starå · 07/24/19

Hi Maiya,

I answered in your other post, but here it is as well.

Try something like this.

=IF(COUNTIF(CHILDREN(); "Red") = COUNT(CHILDREN()); "Red"; IF(COUNTIF(CHILDREN(); "Green") = COUNT(CHILDREN()); "Green"; IF(OR(COUNTIF(CHILDREN(); "Yellow") > 0; COUNTIF(CHILDREN(); "Green") > 0); "Yellow")))

The same version but with the below changes for your and others convenience.

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

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

MaiyaD · 07/24/19

Hi Andre`e,

Thank you so much for your reply. It worked perfectly for my requirement! AMAZING!

I really appreciate your prompt assistance.

Best regards,

Maiya

Andrée Starå · 07/24/19

Excellent!

Happy to help!

Welcome to the Smartsheet Forum Archives

Parent row inheriting status from its children

Comments

Categories