Automation - Email to address in Smartsheet Column
I am trying to send an automatic email when something changes in the Smartsheet. I want to send the email to the email address in one of the columns, however, the only option I'm given is to send it to the "Submitter". However that is a generic user and not an email address. How do I get it to send to the email address in the other column?
Best Answer
-
Hello @Katherine Simpson
You didn't specify how you are getting an email address in that cell, but here's some ideas.
There's a couple ways to go about it. A lookup function based on some criteria to select who to send it to. Possibly adding a option to select who to email within the form. Manually entering an email. A couple options through automations would be to specify who to send it to or input a constant email address by using the change cell value.
The column type has to be a Contact List too.
Answers
-
Hello @Katherine Simpson
You didn't specify how you are getting an email address in that cell, but here's some ideas.
There's a couple ways to go about it. A lookup function based on some criteria to select who to send it to. Possibly adding a option to select who to email within the form. Manually entering an email. A couple options through automations would be to specify who to send it to or input a constant email address by using the change cell value.
The column type has to be a Contact List too.
-
Thank you @MichaelTCA . The email is entered manually by the person filling out the associated form. Changing it to a Contact List worked. I was able to select it in the automation script. Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives