Hello,
I have a Gender column with these options:
Female, Male, Transgender, Non-binary/non-conforming, Prefer not to respond
I need the parent row to reflect a status of RED ball if there is no 'Female' represented in any of the children.
I currently have this formula, but feel I'm missing significant COUNTIF references:
=IF((CONTAINS(FEMALE)(CHILDREN)), "GREEN", "RED")
How can I course correct this formula? THANK YOU!!