Indicating status of Children cells

Admin Account

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.

Genevieve P.

Hi @Admin Account

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

Genevieve P.

Hi @Admin Account

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

Admin Account

Thank you, Genevieve - that did the trick!

Genevieve P.

Wonderful!! Happy to help 🙂