# RYG Symbols in Child rows to update parent row

edited 12/09/19

Hi,

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 green or all child rows yellow (child row may contain red)

Green Symbol - If ALL child rows are green

I created this formula but when all is yellow or few rows have a mix of green and yellow, the parent is turning "red".  Where I want the parent to turn yellow, when rows have mix colors (Red, Yellow, and/or Green).

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

Tags:

• ✭✭✭✭✭✭

Hi Maiya,

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.

• ✭✭✭✭✭✭

Hello,

I've been reviewing the community comments but couldn't work the following out;

I have a Status Sheet for a number of sites we work on.

I'm looking for an IF CHILDREN formula that sits in each PARENT row and looks at the [Alert] column and returns a Red Ball if any of the Children below the Parent contains a Red Ball. I'd use the Red Balls in a report.

Richard.

• ✭✭✭✭✭✭

Try this.

```=IF(CONTAINS("Red", CHILDREN()), "Red")
```

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

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.

• ✭✭✭✭✭✭

Perfect. Thanks @Andrée Starå .

• ✭✭✭✭✭✭

Excellent!

You're more than welcome!

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.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!