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?
Help Article Resources
Check out the Formula Handbook template!