How do I update the Parent Cell so that anytime one of the candidates (listed in the Child Cells)...

Destiny Q

is marked as "Hired" as the Status, it then doesn't count that row? For reference, see the first Parent Column "Accounting - 3 Openings" - however, there is only 1 opening that doesn't have the status as hired and it's not showing that...I tried to add conditional formatting to change the row to "Green" if status is Hired - I want it to do that and then only count the only open one left. For instance, below under Accounting, 2/3 are Green - meaning Hired. 2 out of 3 roles were filled; therefore, I want it to say 1 opening. I hope that makes sense. Thanks!

Andrée Starå

Hi @Destiny Q

I hope you're well and safe!

Try something like this.

="Accounting - " + COUNTIFS(CHILDREN(), <>"", CHILDREN(Status@row), <>"Hired") + " openings"

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!