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

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Ashley McAdoo

    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?

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!