VLOOKUP in Contact Column Issues

I have a sheet using VLOOKUP to populate the email in the Contact Column. There is a notification workflow triggered when the email is populated. The formula is working well but the email is initially populating as plain text and triggering a notification and then, upon saving, the text converts to the contact email and triggers a second notification. Is there a way around this? See below for an example.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!