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

Dynamic Dropdown Filtering in Smartsheet Form
I have a Smartsheet form that is using Dynamic Dropdowns from a "Master List" sheet to select a Name, and Site. I want to filter the Site list based on the Name selected - Is this possible?
Printing Survey Questions and Answers
I have created a survey and had to use the Title box in the form builder to ask the question. This question does not display on the grid column. I would like see the question on the grid sheet and be able to print it with the "Title/Subtitle/Description" showing on the printed page. I know I can do a document builder…
Data is missing
Hello, I created a Smartsheet Project yesterday (trial 30 day user). I input all relevant information including due dates, status, priority, etc. I returned from work just now and logged in to update something on the sheet and all info is missing. I can see the Project Folder but all rows are empty. I tried troubleshooting…