I'm having issues with COUNTIFS - can someone help?
- This works =COUNTIF(Priority:Priority, "P1")
- This works =COUNTIFS(Priority:Priority, "P1") + COUNTIF(Priority:Priority, "P2")
- This works =COUNTIFS(Priority:Priority, "P1") + COUNTIF(Status:Status, "Done") but it adds them up
I can't get the countifs to only show records that are P1 AND (Done OR Declined). I've looked through the community and tried these and none of them work:
- =COUNTIFS(Priority:Priority,”P1”, Status:Status, “Done”) -leaving out Declined just to see
- =COUNTIFS(Priority:Priority, “P1", Status:Status, OR(@cell =
Done”)) Tried using the @cell variable
What I really want is for something like this to work; any ideas?
- =COUNTIFS(Priority:Priority, “P1”, Status:Status, OR(@cell =
Done”, @cell = “Declined”)) - =COUNTIFS([Priority:Priority], “P1”, [Status]:[Status], OR(@cell="Done", @cell=“Declined")
Tags:
Answers
-
Closing parens didn't copy in that last example, but I have tried
=COUNTIFS(Priority:Priority, “P1”, [Status]:[Status], OR(@cell="Done", @cell=“Declined"))
-
Try,
=COUNTIFS(Priority:Priority, @cell = "P1", Status:Status, OR(@cell = "Done", @cell = "Declined"))
~MR
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!