Automation to email entered in form not in a contact list
This response was posted to the same question I have. What I can't figure out is what formula to do I use to get the email into a new column.
If you don't want to use a Contact List field on the form, but want the automation once the row gets to the sheet, create a text field to receive the email address on the form and then a column formula in a Contact List field that references the value in the text field. Then run your automation on the Contact List field.
THANKS!
Answers
-
Hey @dbussiere,
If you're asking how to make the field on the form a required email address, you would do it here when building out the form:
Then when you're doing the automation, the column this field is tied to will be an option as an email to send it to.
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
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