Counting Items mentioned once in a multi drop down option
How do I have on a tracking sheet where as long as the item is mentioned in a multi choice cell, it counts that item I am requesting? "At Risk Associate" needs to show 4 times, but doesn't show anything. I use COUNTIFS and tried HAS but nothing has worked.
Answers
-
COUNTIF and HAS would be exactly what I would do in this situation. Are you receiving an error, or an incorrect count? It would be helpful to see the formula you tried and a screen capture of your sheet, but please block out any sensitive data.
Here's an example of the COUNTIF and HAS together, in a cross-sheet formula, using @cell:
=COUNTIF({Referenced Column}, HAS(@cell, "Criteria"))
The "Criteria" could either be built into the formula "like this", or it could be a referenced cell [Like this]@row.
You could add other criteria in a COUNTIFS as well, if you'd like:
=COUNTIFS({Referenced Column}, HAS(@cell, "Criteria"), {Other Column}, "Other Criteria")
Let me know if you still need help!
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
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 306 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!