Alerts based on lookup

I have a column in a sheet which is a Multi Select Dropdown with a number of roles listed. I want to set up alerts to individuals, sending them the rows in which their role is mentioned. The email addresses relating to each role are held in a separate sheet. Is there any way I can use lookup to send the alert to the correct email address without having to hard code this in the automation?

Thanks,

David

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!