Trouble Adding Multiple Emails to Form Field and Automating Alerts in Smartsheet
Best Answer
-
Hi @LBird,
To fix this issue, make your column a "Contact List" column. This will allow users to enter multiple email addresses and SmartSheet will validate that the user enters correctly formatted email addresses.
This will also fix the notification issue. Once the emails are added into a Contact List column, you will be able to select these emails to use in a notification alert. If the emails are not in a Contact List, then you will not be able to find the emails.
Hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β Auto Sorting β Sorting with Filters β Report PDF Generation β Copy and Paste Conditional Formats β Copy and Paste Automation Workflows β Column Manager β and so many more.
Answers
-
I am also having issues adding multiple emails to a form field. When I select "Email" in the form field settings, and I add a comma, it displays an invalid email address message. If I mark the box no validation and use the multiple-line text box option, it does allow for multiple email addresses separated by a comma and fills in the correct column/cell in the Smartsheet; however, when I try to create an automation to send an email to these email addresses, the column does not appear as a selection in the Select an action>Alert someone section. Not sure if there are more specific details about how to add multiple email addresses in a form field in Smartsheet University, but if not, having specific details on what to select in the Field settings would be helpful. Like which settings to select throughout the entire Field settings options.
-
Hi @LBird,
To fix this issue, make your column a "Contact List" column. This will allow users to enter multiple email addresses and SmartSheet will validate that the user enters correctly formatted email addresses.
This will also fix the notification issue. Once the emails are added into a Contact List column, you will be able to select these emails to use in a notification alert. If the emails are not in a Contact List, then you will not be able to find the emails.
Hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β Auto Sorting β Sorting with Filters β Report PDF Generation β Copy and Paste Conditional Formats β Copy and Paste Automation Workflows β Column Manager β and so many more.
-
Thank you so much! That worked perfectly. I tried the contact list before and it gave me a drop-down list so I thought that was wrong.
-
You're welcome! Glad that you got it working.
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β Auto Sorting β Sorting with Filters β Report PDF Generation β Copy and Paste Conditional Formats β Copy and Paste Automation Workflows β Column Manager β and so many more.
