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!
