COUNTIF's Formula Multiselect dropdown + Status
I'm trying to create a sheet summary for the number of items with a status of work in progress under each person. Team Member Assigned To is a multiselect option with several names listed. When I use the formula below, I get a return of 0.
=COUNTIFS([Assigned To]:[Assigned To], CONTAINS("NAME", @cell), STATUS:STATUS, "In Progress")
I have also tried -
=COUNTIFS([Assigned To]:[Assigned To], HAS(@cell, "NAME"), [STATUS:STATUS], "In Progress)
This one is Unparseable
Best Answer
-
Try HAS instead of CONTAINS. HAS is formulated backwards from contains fyi
=COUNTIFS([Assigned to]:[Assigned to], HAS(@cell, "Name"), Status:Status, "In Progress")
Answers
-
Try HAS instead of CONTAINS. HAS is formulated backwards from contains fyi
=COUNTIFS([Assigned to]:[Assigned to], HAS(@cell, "Name"), Status:Status, "In Progress")
-
I was so close! Thank you, Dan!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!