Values Dropdown List in a form
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.
Answers
-
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!
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!
-
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.
-
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?
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!
-
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
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