Automation: Send to contacts in a cell

Jason McGuire

Hi,

I'm having an issue where an automation won't send an email. My personal settings are correct. It will send the email if I input an email address, but it will not dynamically pull that email from the submission. I.e, it's a mutliple form, and the form gets filled out by X person, who inputs into one of the contact lists, then it should email that person. It will send it via the teams plug-in, but not all users want to have that enabled.

See screenshots.

Thanks for your help.

Jason

Andrée Starå

Hi @Jason McGuire

Strange!

Could it be one of the following that might be the reason for it not working?

App-generated emails not being received

https://status.smartsheet.com/incidents/pwby2k48svsw

Have a look at this post for information on recent changes to email domains that might be the reason it not working.

https://community.smartsheet.com/discussion/69408/action-needed-add-new-smartsheet-email-domains-to-your-trusted-sender-list

Did that work/help?

I'd be happy to take a quick look if the above didn't help solve it.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jason McGuire

Hi Andree,

Thanks for providing some help. I'll try what you mentioned above, but here are the sheets:

PM fills this one in first:

https://app.smartsheet.com/b/form/353ea12d961140c18f1a9cc6eb4fe497

Once that is filled out, it triggers the second form to be sent to the people in the contact cells:

https://app.smartsheet.com/b/form/e61bcaa88dbf415bb999cb81fc6afa82

I've turned security off so that you can see it.

Thanks

Jason

Jason McGuire

Hi Andree

Thanks for being proactive, but I think we got it to work, we have the url in the email body and send it to multiple people so the emails got filtered out and went to spam folder in our email security system.

Andrée Starå

@Jason McGuire

I'm always happy to help!

Glad that you figured it out!

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!