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.

Find more posts tagged with

Accepted answers

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

All comments

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 🙂

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.