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
-
Change the trigger settings from "When triggered" to Hourly. That way the cell will already have updated itself by the time the trigger happens.
-
Thanks for the suggestion. I would think that would work in theory but I am getting an error when I try to trigger the automation to run hourly. I have looked into which workflows can't be run using hourly, daily or weekly triggers and mine does not seem to violate those rules but apparently I am missing something.
-
-
Can you show me how to create the Vlookup to put the email in the contact column? I'm struggling.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!