Indicating status of Children cells
Hello - we have a sheet with Health symbols for the Tasks which are children under Phases of a project. I'd like to be able to indicate on the parent cells of the Health column if there is a non-green symbol among their Children cells in the Health column. Preferably the result is either nothing or a Yellow symbol. Here are my unparseable formulae attempts:
=if(countifs((Children),<>"Green")>0,"Yellow")
=if([Health]3:[Health]12,<>"Green")>0,"Yellow")
Any advice is welcome.
Best Answer
-
You're on the right track! The CHILDREN function though needs a column to reference...
ex. CHILDREN(Health@row)
or if this formula is in the Health column, you leave the parentheses blank:
ex. CHILDREN()
Try this:
=IF(COUNTIF(CHILDREN(),<>"Green") > 0, "Yellow")
Or Add Green:
You may also want to add a rule that says that otherwise, if they're all Green, return a Green ball...
=IF(COUNTIF(CHILDREN(),<>"Green") > 0, "Yellow", "Green")
Let me know if this works for you!
Cheers,
Genevieve
Answers
-
You're on the right track! The CHILDREN function though needs a column to reference...
ex. CHILDREN(Health@row)
or if this formula is in the Health column, you leave the parentheses blank:
ex. CHILDREN()
Try this:
=IF(COUNTIF(CHILDREN(),<>"Green") > 0, "Yellow")
Or Add Green:
You may also want to add a rule that says that otherwise, if they're all Green, return a Green ball...
=IF(COUNTIF(CHILDREN(),<>"Green") > 0, "Yellow", "Green")
Let me know if this works for you!
Cheers,
Genevieve
-
Thank you, Genevieve - that did the trick!
-
Wonderful!! Happy to help 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!