Find function stops working for contact type column

Alan Phuan

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

Bassam Khalil

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

Alan Phuan

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.

Bassam Khalil

@Alan Phuan 

please try the same VLOOKUP formula in the new sheet and check are you facing the same problem you facing in the original sheet.