I can not figure out what is wrong with my CountIFs formula
I have a formula that returns the number of Volunteers we have signed up IF they are assigned to any stand (it will not count them if they are assigned Waitlist or $$). My current formula that IS working is: =COUNTIFS((Contact:Contact), <>"", (STAND:STAND), <>"*Waitlist", (STAND:STAND), <>"$$")
It works great. However, I want to add in that the Volunteer should NOT be counted if they are listed as a No Show (they didn't show up, which is noted in the Lead column)
I attempted to do this by adding (Lead:Lead), <> "No Show" My entire formula I used was: =COUNTIFS((Contact:Contact), <>"", (STAND:STAND), <>"*Waitlist", (STAND:STAND), <>"$$", (Lead:Lead), <>"No Show")
However, when I do this to the formula, it returns the value of 0. The value was 3 prior to adding the No Show part of the formula. What am I missing? It seems like it must be something so simple.
Best Answers
-
Hey @RiseUpPNW,
To clarify, it should only count if a contact is entered, they're not on the waitlist or $$, and they're not a no show?
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Nothing jumps out to me as why it wouldn't work. I did try a slightly different version if you want to give this one a try. It worked for me:
=COUNTIFS(Contact:Contact, NOT(ISBLANK(@cell)), STAND:STAND, NOT(OR(@cell = "*Waitlist", @cell = "$$")), Lead:Lead, NOT(@cell = "No Show"))
Answers
-
Hey @RiseUpPNW,
To clarify, it should only count if a contact is entered, they're not on the waitlist or $$, and they're not a no show?
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Nothing jumps out to me as why it wouldn't work. I did try a slightly different version if you want to give this one a try. It worked for me:
=COUNTIFS(Contact:Contact, NOT(ISBLANK(@cell)), STAND:STAND, NOT(OR(@cell = "*Waitlist", @cell = "$$")), Lead:Lead, NOT(@cell = "No Show"))
-
@bisaacs Correct!
-
Hey @RiseUpPNW,
It appears the formula won't count a row if the Lead column is empty using your formula, but @Nic Larsen's works!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!