Formula is not pulling contact list name

Formula is not pulling contact list name

Hi,

My formula used to work when the field was just a drop down list. Now that we changed it to a Contact list, the formula stopped working. I tried listing the persons full name, tried adding the email address with the name, just like it is in the contact list. but still i am not getting any results.

=COUNTIFS({2020 TRACKER Range 2}, "Danita", {2020 TRACKER Range 1}, [Column2]2)

Comments

Sign In or Register to comment.