Find function stops working for contact type column
The following formula used to work but stopped working recently. Anyone encountered the same issue and managed to resolve it?
=COUNTIFS([Assigned To]:[Assigned To], FIND("Name", @cell) > 0)
"Assigned To" is a contact column
Answers
-
Hi @Alan Phuan
Hope you are fine, i tested your formula and it's work perfectly, please try to create a new test sheet with the Assigned To column and try the formula if you face the same problem then Contact Support
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 @Bassam.M Khalil ,
Thanks for looking into this!
I created a new sheet and the formula does work. Looking into the issue again, the difference between the new sheet and existing sheet is that the contact column in the existing sheet is actually a vlookup formula that retrieves contacts from another sheet.
-
please try the same VLOOKUP formula in the new sheet and check are you facing the same problem you facing in the original sheet.
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"
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives