Count if it contains
I have an action log - allocations vary between one person only and multiple persons.
Want to do a count (in a separate file) of allocations to each team member. This formula:
=COUNTIF({Action Log Range 3}, Name1) counts only those actions allocation to ONLY that team member.
--- Action Log Range 3 = action allocated to...; Name1 = names listed in my sheet with formulae ---
How do I change the formula to say that in the Action Log Range, if it contains the name listed in my sheet, then it counts it as one?
Best Answer
-
Are you using a contact type column? If so then you would need to use a FIND instead of CONTAINS.
=COUNTIF({Action Log Range 3}, FIND(Name1, @cell) > 0)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Try using this...
=COUNTIF({Action Log Range 3}, CONTAINS(Name1, @cell))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
My answer changes from 3 to 0 - I know that it should be 5 if it counts all actions allocated individually + as part of the group.
Thanks - any other ideas for me please?
-
Are you using a contact type column? If so then you would need to use a FIND instead of CONTAINS.
=COUNTIF({Action Log Range 3}, FIND(Name1, @cell) > 0)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you Paul.... very, very much!
-
Happy to help! 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!