How to count a value with multiple selections
I'm trying to count a value with multiple selections, but I can't seem to get the correct answer
here's the formula I've tried but none of it works.
=COUNTIFS([Resolution Action Taken]:[Resolution Action Taken], "Conversation with Employee", [Ticket Type]:[Ticket Type], "Client Service Escalation")
=COUNTIFS([Ticket Type]:[Ticket Type], "*Client Service Escalation*", [Resolution Action Taken]:[Resolution Action Taken], "Conversation with Employee")
Remarks: "Resolution Action Taken" (with multiple selection as column property)
Answers
-
Does this work:
=COUNTIFS([Resolution Action Taken]:[Resolution Action Taken], CONTAINS("Conversation with Employee", @cell), [Ticket Type]:[Ticket Type], "Client Service Escalation")
-
You're a genius @Nic Larsen! It worked!! thank you so much. 🤩
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!