Reference looked up emails for automation

[Amy_Herman]

Hi there,

I have a communications calendar that I’m trying to have automate some email sends through the Gmail automation. I have my emails on that table as a lookup field, but the automation isn’t recognizing it as an email address so it’s failing the test.

Is there a formula that will basically copy what’s being looked up and just format properly so that it’s an email address?

Thank you for your help!

Amy

[Kamille_Parks]

If you have a working Lookup field, which I can tell you do based on your screenshots, you should be able to add a Rollup field using the exact same process you did for the Lookup field.

[Amy_Herman]

Woohoo! I got the Lookup field to work. Unfortunately, I’m still getting the error I mentioned above. Here are some fresh screenshots.

[Amy_Herman]

@Kamille_Parks I think the ARRAYJOIN() fixed it! I think you and @ScottWorld are going to keep me sane. Thank you for your help (and for repeating yourselves). I have my automation set to run tomorrow, so wish me luck!!