Count if Production is anywhere in the cell.
PDCA range 2 is a drop down list. It is counting it if Production is the ONLY thing selected. If there are multiple things selected, it wont find it in the list and count it. Formula =COUNTIFS({PDCA Range 2}, "Production", {PDCA Range 1}, FIND("OK 3", @cell) = 0)
Best Answer
-
Hi @Brandon03
With multi-select dropdown lists, you can use the function HAS to see if the cell has this one specific entry. It looks like your Range 1 is similar, is that correct? I would suggest using HAS in both instances...try something like this:
=COUNTIFS({PDCA Range 2}, HAS(@cell, "Production"), {PDCA Range 1}, HAS(@cell, "OK 3"))
Let me know if this works!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @Brandon03
With multi-select dropdown lists, you can use the function HAS to see if the cell has this one specific entry. It looks like your Range 1 is similar, is that correct? I would suggest using HAS in both instances...try something like this:
=COUNTIFS({PDCA Range 2}, HAS(@cell, "Production"), {PDCA Range 1}, HAS(@cell, "OK 3"))
Let me know if this works!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!