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!