Populate cell based on child values

Suzanne Raphael
Suzanne Raphael ✭✭✭
edited 02/05/20 in Formulas and Functions

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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!