Contains Function cannot find value for contact list data type
Hello,
I'm trying to use the COUNTIF and CONTAINS functions to count the values in the percent column based off the values in the Names column with the contact list column type.
Here is the formula I have so far:
=SUMIF(Names1:Names3, CONTAINS("Anthony", @cell), Percent1:Percent3)
And here is the data:
When I change the data type to text, it works. But when I have the Names column set to the contact list data type, it returns 0 (I'm assuming that means the CONTAINS function found no matches).
Is there a different function I should be using other than CONTAINS that will work with contact lists?
Thanks!
Anthony
Answers
-
Hello @Anthony893
In my experience using formulas on Contacts List columns can be problematic.
You may want to explore using a helper column next to "Names" that is text with ="[Names]@row"
Then use your formula against the helper column to achieve your desired result.
https://www.linkedin.com/in/zchrispalmer/
-
Hey @Mr. Chris,
Thanks for the quick reply, I think that's going to be my best solution.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!