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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!