Multiple contacts per cell not receiving automated update requests
I have an email contact list being populated by a Vlookup that is part of an automated workflow. I have "allow multiple contacts per cell" checked as part of the column parameters, but in every cell where there are two email addresses needed, the automated update requests are not being sent. Any suggestions?
Best Answer
-
I can see that in the workflow sheet the column values are actually being returned as Text, not as a Contact (there are no circles next to the email addresses). It also looks like it's pulling through a different value... the email...are you sure the formula is bringing back the right column?
I would suggest editing the Reference that the VLOOUP is looking at to ensure it's finding the right Contact Column and not another Text column that contains emails.
Can you paste your formula here, and identify what column number in your reference it's pulling data from?
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
What does the source sheet look like for the VLOOKUP? How are the contacts stored in this sheet?
The source sheet would need to have the contacts set up in a multi-contact column so that the VLOOKUP could bring back the correct multi-contact value. Are the formula values being returned with the contact circle next to the email/name?
Can you post a screen capture of your source sheet and your current sheet where the workflow is built (but please block out sensitive data).
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
The lookup sheet column is formatted for multiple contacts per cell, and the contacts are being returned correctly on the workflow sheet. All the single contacts are receiving the automated emails, but every row where there are multiple contacts they are not.
This workflow used to work, but apparently stopped a few months ago.
Thanks,
Ashley
-
I can see that in the workflow sheet the column values are actually being returned as Text, not as a Contact (there are no circles next to the email addresses). It also looks like it's pulling through a different value... the email...are you sure the formula is bringing back the right column?
I would suggest editing the Reference that the VLOOUP is looking at to ensure it's finding the right Contact Column and not another Text column that contains emails.
Can you paste your formula here, and identify what column number in your reference it's pulling data from?
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
That seems to have fixed it. Thanks so much!
-
No problem! 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!