Sign in to join the conversation:
Is there a way to do email address validation in Smartsheet forms or in Workflows? Using condtions such as contains '@' or '@domain.com' isn't sufficient and I can't alert form submitters that they did not submit to the form correctly.
Hi Eric,
Why wouldn't CONTAINS or similar work?
What do you want to check?
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!
Have a fantastic day & Happy New Year!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
I believe I have the same question. In my case, I am creating a form that requires a field be completed using an email address rather than just a name. How can I make an email address format the required value?
Hi @KATY PRUETT
Do you have a column in your sheet that's a Contact List type of column? You can make this a required field.
Here's more information on the Contact List type of column: https://help.smartsheet.com/articles/2480241-column-type-reference#contactlist
@Genevieve P I just tried the suggestion above and it doesn't seem to work as I expected.
I have a form where I want to make sure that people give me an email address that contains at least an "@" symbol and a "." so if the individual on the form enters kasel, it should prevent them from saving or give an error, vs if they say kasel@gmail.com it lets them save.
Hi @Kasel Lesak
Could you implement @Andrée Starå 's solution of setting up a workflow to check if there's an @ or .?
If you put it in a workflow as a condition, like this, then you could send an Update Request to the user who submitted the form (this would require that they log in to fill out the form so Smartsheet can capture the email that way).
Otherwise, I would make sure that your helper text is extremely clear:
Has anyone at Smartsheet seen how ridiculously easy format validation is on the FREE Google forms app?
I couldn't put my help text in clearer words. NO ONE reads or follows that help text.
There seem to be forum posts going back to 2016 of people asking for this very basic functionality. But I only see responses with goofy workarounds and no indication that Smartsheet understands the value.
I agree with David - this is pretty basic functionality for many competitors so its seems strange it hasn't been implemented. As always, there is a hack that will get you 70% of a solution...
I'm not sure the proposed hack works either. If I want to add a Contacts list to the form but allow the user to enter a new email then I don't think I can use CONTAINS to do what is suggested. The form field would need to be a text entry.
Here is a solution: On a Form you want to have Email entry: Name@doman.com: That column on the back end needs to be a text field. Then you have a second column with the formula " =Email@row" That column should be set up as a contact field and for all your automations. This will duplicate the email into two columns- One as a Text, second as a Contact. Now to Validate the information. Set up a Third Column and use the following formula: =IF(CONTAINS("@doman.com", [Email]@row), "True", IF(CONTAINS("@Doman2.com", [Requestor Email]@row), "True", "False"))
This will allow you to have a Domain validation check on entries. If the Email is not from @domain.com or @Domain2.com, it will produce a False in the Validation column and allow you to prevent it from going further into workflows or approvals or even kick an error back out, you could also have it auto cancel or delete a ticket based on that false information. If True it proceeds to other processes.
Also your Email Entry Column now can have Email validation on the text field to ensure it's at least a proper email address, if its from a bad domain like a gmail.com then the above solution handles that so personal emails can't be used in a process.
It would be better if some kind of regular expression matching could be implemented. This would allow users to set up varied types of matching, not just emails. This would be a very powerful feature to implement. Users could set up something like "[:alphanumeric:]_[:alphanumeric:]@domain.com" or "[:alphanumeric:].[:alphanumeric:]@domain.com" to validate emails, but could also use the feature to validate other types of data.
Is there a solution to have validation two fields in the form ?
I'm using a form to capture email address and want to make sure the user types the correct email address.
So, I have created a new field for email but how can we validate two fields?
If the user types second wrong, smartsheet should prompt the user to enter new email address.
Any input will be highly appreciated. Thank you!
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…
