Did they change how contact list and formulas interact?

I have a sheet that is mapping the supervisor email from a different sheet using vlookup (I want to keep this formula active in case there are supervisor changes). The format for the supervisor email is contact list. I'm using the supervisor email mapped in a countifs formula that was working last week. Now I'm getting #NO MATCH when nothing has changed. Last week it was working perfectly, suddenly everything is broken.

Anyone else experience this issue?

Tags:

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!