How to get COUNTIFS to include selection within a "Dropdown List" of multiple values per cell.
Hi Smartsheet Support Community!
I monitor the marketing and communications request for support log for our organization. We currently use one column to inform our team if a request needs writing, graphic design, or both.
Whenever I use my COUNTIFS formula for graphic design, it isn't including the rows that have both selected, it is only including the options when graphic design is solely selected.
How do I get my formula to count anytime one of the options is selected?
Here's my formula:
=COUNTIFS([2. Service center support type]:[2. Service center support type], "Graphic design or photo/video support (digital & print, photo selection & editing, video editing)", [Submission date]:[Submission date], >=DATE(2024, 1, 1), [Submission date]:[Submission date], <=DATE(2024, 12, 31))
We currently have a total of 33 Graphic design requests for the year, but the formula is only counting 27 because the other six have Writing included in it. How do I get it to count to include both?
Best Answer
-
Formulas dislike dropdowns that allow multiple selections. You'll need to use Contains or Has functions, depending on your situation.
See discussion below. There are a lot of threads on the community about this question.
Answers
-
Formulas dislike dropdowns that allow multiple selections. You'll need to use Contains or Has functions, depending on your situation.
See discussion below. There are a lot of threads on the community about this question.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!