Count IF and Contain help?
I am using this formula to count how many tasks are RED and assigned to an Assignee. It does not seem to be picking up if the Task has been assigned to multiple people. For example. If the Task is assigned to Bob and Sally as an assignee it wont pick that task up. Is there a way to do a CONTAINS off of the Team11?
=COUNTIFS({Tasks Range 1}, Team11, {Tasks Range 4}, "RED")
Answers
-
Hi @Greg Zinn
Hope you are fine, please try the following formula:
=COUNTIFS({Tasks Range 1}, CONTAINS("Team11", @cell), {Tasks Range 4}, "RED")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hello I think this is close Khalil.. "team11" is not the search term I am trying to pull then Name of the person from the field in the sheet called team. Any tweaks?
-
Could you share me as an admin on a copy of your sheets after removing any sensitive data and I will try to fix it for you.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi Khalil thanks for that offer but I will have to seek another pathway for resolution.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!