Counting Children rows with certain formatting.

styless

I am trying to count how many openings each time I added a children row. However, I wanted it to NOT count the Openings if one of the candidate is already hired into that position and or if the HM's decision column is changed to "Hired".

 

This is the sample sheet: https://app.smartsheet.com/b/publish?EQBCT=2803d980563e404aa1adcfcca899a744

 

Thank you!

styless

Got this figured out. Thanks!

Paul Newcome

So you are trying to count the Gray rows who's children rows do not contain "Hired" in the [HM's Decision] column?

Andrée Starå

Hi,

Excellent!

Thanks for letting us know!

If you'd like you could add a post on how you solved it if others with the same scenario come around this post.

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD