Values Dropdown List in a form

Stefano Mauro

Good morning everyone,

I would like to ask if is possibile, in a dropdown list inside a form, to insert a value like 'GENERAL DIRECTOR' but the cell in the sheet is filled with a mail (example generaldirector@mail.it). Is possibile to do this kind of association? I hope I have explained the 'problem' clearly.

Or the only way to do it is to create another sheet where I put the value and the corresponding mail, then use a formulas to have the mail in the sheet that I need?

Thanks for the support.

bisaacs

Hey @Stefano Mauro,

You could use a formula in a Text Column to list an email address based on the dropdown selection. So, in your example, you would put this formula:

=IF([Dropdown Column]@row = "General Director", "generaldirector@mail.it", IF([Dropdown Column]@row = "Next dropdown option", "employee@mail.it", IF(etc…)))

Hope this helps!

Stefano Mauro

https://community.smartsheet.com/discussion/comment/438100#Comment_438100

Hi, thanks for your reply. I tried the solution and it works but I would like to know if there is the possibility to do it without creating a new text column. So do all the operations in the Dropdown Column, but I think it's not possibile.

Thanks a lot for your advice.

bisaacs

Hey @Stefano Mauro,

Unfortunately you aren't able to do both a user dropdown selection and a formula in the same column. You could have the dropdown list show on the form then hide the on the sheet (while having the Text field not on the form), would that work?

Stefano Mauro

https://community.smartsheet.com/discussion/comment/438111#Comment_438111

I have just modified the sheets in that way, because I have also some workflows that are using the Dropdown column. Let's see if the customer likes this solution!

Thanks a lot for your help