Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

"Forms" Can I use a drop down field to direct the form information to a specific email address?


I am looking to use a drop down in the form to direct the form details to a specific email address. For example: If i choose a specific country from the drop down the details of the form would be directed to an email that i configure. If is select a different country it would go to a different email address.




  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 11/26/15



    The form details go directly into a new row in your sheet, either top or bottom as configured under the form options. Once it is in the form, you could redirect the information via a reminder.


    Unfortunately, a contact column does not support formulas.

    I would have used a formula and the Autofill feature (which works from Webforms) if it did. 


    How many countries and how many emails are needed?

    If there are not many, you could set up a form for each, with the difference being the default value for the contact column (which could be hidden from the form's end user).

    A notification could then be set up to trigger when the information is added and go to the person in the contact column.


    Alternatively, there are third party software such as Azuqua that monitor Smartsheets and take action based on what has occurred. I believe there are others besides Azuqua but I have not tested them yet.


    Even more alternatively, you could have the info go to a single email address and use the email programs to parse and redirect the email to its correct reciepient. This feels like a hack, but could be simple to set up.


    Or maybe I missed an obvious solution. 


    Hope this helps.



  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    Well described Craig, we like Azuqua for just that too! 



  • Travis
    Travis Employee

    Azuqua is a great option for this! I also recommend Zapier which can do this as well, but has a free version of their app (Azuqua is paid only). 

This discussion has been closed.