#### 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.

# Parent row inheriting status from its children

Options
edited 12/09/19

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)

• ✭✭✭✭✭✭
Options

Matt

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

https://help.smartsheet.com/functions

RichardR

• Options

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"))

• Options

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

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

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

• ✭✭✭✭✭✭
Options

Excellent!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

This discussion has been closed.