nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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!

Find more posts tagged with

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Can't access issue submission
I have run into an interesting but small bug. When setting up an automation, the action 'change cell value' will allow you to select checkbox columns, but not checkbox columns that are the star or flag visual variant. Those can't be selected in the change value action. Now the real issue. I go to submit a bug report or…
Setting up the welcome and help screens.
Hello All, I am having difficulties uploading my information to the welcome and help screens. We are a Micro Soft 365 shop, using share point, and I am getting the error message that share point in refusing to connect. Whereas this appears to be a share point issue; I have reached out to our IT Department, and we cannot…
Contact List validation
Hi Everyone, I am managing a pipeline tracking sheet, and there's one intake form and one dynamic view connecting with this sheet. For the column "Branch Contact" and "Sales leader", I set the filed type as "Contact list" and the validation as "No validation". Once I input the username in the intake form, I go to the…