Sign in to join the conversation:
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!
Got this figured out. Thanks!
So you are trying to count the Gray rows who's children rows do not contain "Hired" in the [HM's Decision] column?
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
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
