Populate cell based on child values
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
-
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
Answers
-
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
-
Thanks, Jayesh! Very, very helpful. I tried a couple using COUNT, but couldn't make that work.
Cheers!
Suzanne
-
Here is another option...
=IF(CONTAINS("NG", CHILDREN()), "NG", "GO")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!