Counting items from a multiple drop down list
I have a list of action items that can be assigned to several departments by using a multiple drop down list with dept. names in the assigned column
I am trying to create a summary sheet to count the number assigned
I have tried both Contains & HAS
But my answer is 0  Just using the count if gets me 23 and there are 2 where multiple depts are chosen including OPS so I should have 25.
Using HAS
Once again my answer is 0
The {LL Action Tracker Range 1} is my assigned row in my main sheet
Thank you!
Best Answers


Hi @Amy A
Try this:
=COUNTIFS({LL Action Tracker Range 6}, <>"", {LL Action Tracker Range 1}, HAS(@cell, Section@row))
With a COUNTIFS you'll always want to list the {column} first, then your criteria. The HAS is the criteria, which is why we list is after the {range}. Let us know if this makes sense!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Answers


Thank you very much!!

I was hoping by helping me with this item, I could figure out my countifs but no such luck.
I am trying to also then identify these counts on my summary as completed & open by priority.
This above has worked for my countif
This has worked for my completed: =COUNTIFS({LL Action Tracker Range 6}, <>"", {LL Action Tracker Range 1}, Section@row)  but does not include those with multiple dropdown  I have tried the HAS & CONTAINS formula with no luck
Is NOT working:
=COUNTIFS({LL Action Tracker Range 6}, <>"", CONTAINS(Section@row, {LL Action Tracker Range 1}))

Hi @Amy A
Try this:
=COUNTIFS({LL Action Tracker Range 6}, <>"", {LL Action Tracker Range 1}, HAS(@cell, Section@row))
With a COUNTIFS you'll always want to list the {column} first, then your criteria. The HAS is the criteria, which is why we list is after the {range}. Let us know if this makes sense!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
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!