Countifs with multiple criteria
Hello,
I am trying to figure out a formula to capture a specific person and how many opened or closed cases they have.
My fields are
Analyst and Date Closed
So for the analyst, let's say i am trying to find out how many cases Leslie King still has open, that would be annotated with the date closed field being blank, and then vice versa if the case was closed. Any help would be appreciated
Comments
-
Open:
=COUNTIFS(Analyst:Analyst; ="Leslie King"; [Date Closed]:[Date Closed]; ="")
Closed:
=COUNTIFS(Analyst:Analyst; ="Leslie King"; [Date Closed]:[Date Closed]; <>"")
"" (two quotation marks) means empty
<> means not equal
so <>"" is [not empty]
Hope this helps
Best regards,
Marcel
-
Thank you. I just tried it and it comes up as unparseable. Doe it matter that it's pulling the name from a contact field?
-
Try swapping the semicolons for commas. Some regions have a different symbol used between formula sections.
-
Thank you soooo much!
-
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives