Populate cell based on child values

Suzanne Raphael

I have a column that has as its header "GO/NG" (go/no-go), which uses a drop down menu to select either/or. I have a parent row with some number of children. If all the children have GO value selected, then the GO/NG cell in the parent row should say GO. If ANY of the cells say NG, the parent should say NG. I have tried just to get to all "GO", then "GO," but I don't seem to be able to accomplish even that.

Here's the last one I tried, all have been unparseable:

=IF([GO/NG]2:[GO/NG]6 = “GO”, “GO”, “NG”)

What am I missing?

Thanks in advance!

Jayesh Nathani

Hi,

Following will work if all of your Parent's children has "GO", then the parent will change to GO. This will get you started, you can also add the same statement for your NG.

=IF(COUNT(CHILDREN([GO/NG]@row)) = COUNTIF(CHILDREN(), "GO"), "GO", "NG")

Hope it helps!

Thanks,

Jayesh

Jayesh Nathani

Hi,

Following will work if all of your Parent's children has "GO", then the parent will change to GO. This will get you started, you can also add the same statement for your NG.

=IF(COUNT(CHILDREN([GO/NG]@row)) = COUNTIF(CHILDREN(), "GO"), "GO", "NG")

Hope it helps!

Thanks,

Jayesh

Suzanne Raphael

Thanks, Jayesh! Very, very helpful. I tried a couple using COUNT, but couldn't make that work.

Cheers!

Suzanne

Paul Newcome

Here is another option...

=IF(CONTAINS("NG", CHILDREN()), "NG", "GO")