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
We are a construction company and I am trying to build automations and a dashboard for tracking "Outstanding Update Requests" - Each of our Line-Item tasks require us to acquire information from 3rd parties. This information takes standard forms (Start Date, End Date, Comments, Attachments, etc), but the specific fields…
Since I tried to report this as a technical issue and was redirected by a useless AI to this Community, I'd like to ask if anyone here has had the same experience? Screenshot attached, and needless to say, it is not convenient at all.
What happens if a System Admin deletes a user who owns items without transferring those items to another user?
