countifs multiple drop down menu selections
Hello,
I am trying to use countifs to see how many Priority types do not have an Approval and have a specific Inventory Org. The issue I am coming across is if there are multiple selections under the Inventory Org dropdown-multi select column.
Have tried to use CONTAINS and HAS nested into COUNTIFS without success. Any recommendations?
Thank you!
Answers
-
Maybe showing you this formula working will help you to get yours working?
Formula:
=COUNTIF([Column4]:[Column4], CONTAINS("Gary", @cell))
If not, could you please copy/paste your non-working formula into this thread and we can possibly help you troubleshoot it. CONTAINS searches for a piece of information. HAS will need an exact match.
-
@Mike TV , unfortunately that isn't working.
Current formula: =COUNTIFS({Inventory org}, CONTAINS("BGM", {Inventory org}), {Priority1}, [Primary Column]@row, {Approval}, "")
This formula works for all single selects from the Dropdown-Multiple Select Inventory Org column.
-
=COUNTIFS({Inventory org}, CONTAINS("BGM", @cell), {Priority1}, [Primary Column]@row, {Approval}, "")
Does this work?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!