Trouble Adding Multiple Emails to Form Field and Automating Alerts in Smartsheet

System

This discussion was created from comments split from: How to add multiple email addresses in a form field for email notification purposes?.

SSFeatures

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!

LBird

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.

SSFeatures

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!

LBird

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.

SSFeatures

You're welcome! Glad that you got it working.