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
Hello, I have two sheets. One is "Current tasks" and one is "Completed tasks". I have the rows (individual tasks) auto number when entered (2026-001, 2026-002, etc.). When the row is marked complete, it is moved to the "Completed task" sheet. The problem I am having is that when the row is moved the other tasks that remain…
Its very frustrating when you are adding multiple columns and having to use the slide bar to move to the end and then click the 3 dots and add another column. Seems there has to be an easier more productive way.
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
