COUNTIFS for assigned to CONTAINING a name
I'm trying to total the numbers of active assignments assigned to a person in a cell that can have muliple selections. .... it's not giving me an error but coming back as 0
=COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("name", @cell), Status:Status, <>"completed")
Anyone help!?
Answers
-
Do you allow for multiple contacts in each cell? If not the formula below will work.
=COUNTIFS( [Assigned To]:[Assigned To], "Vanessa Williams", Status:Status, <>"completed")
-
If there are potentially multiple contacts in the individual cell you can use this trick:
=COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("Vanessa Williams", join(@cell)), Status:Status, <>"completed")
-
Yes, I need to allow for multiple contact and count accordingly, even if more than one contact is selected.
-
I have posted a second formula above in the case that there is a requirement for multiple contacts.
-
I wasn't able to get that to work, but this ended up working well:
=COUNTIFS([Primary (Assigned To)]:[Primary (Assigned To)], FIND("vanessa", @cell) > 0, Status:Status, <>"completed")
-
CONTAINS doesn't seem to work for the "Assigned To" Column but find does.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
