Drop down list Formula.

joe.quinones
joe.quinones ✭✭
edited 12/09/19 in Formulas and Functions

I am having issues developing a formula for a drop-down list/ Assigned to.  The goal is when some select one of the departments (attached image). Then in the same row in the Assign To column will populate the right contact for that department. In some departments, there will be multiple contacts and when those contacts are entered in the cell they will get a notified email.  Is this something that can be accomplished?  My first thoughts were an IF function.

 

=IF(Department1 = "Product", "email"),AND(Department1 = "VDC", "email"),AND(Department1 = "PreFab M", "email"),AND(Department1 = "PreFab P", "email"),IF(Department1 = "PreFab E", "email")

Capture 2.JPG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!