I'm building a sheet that contains various users in different roles on different teams. I'd like to email the users listed in a column when a change is made to a record.
ex. I capture a program manager name in column D and when a change is made to any columns in the row, I want to email the admin (easy, set up an alert for any changes) and whomever is listed in column D. Is there a way to do that? What about emailing people from multiple columns, like a program manager (column D) and a product owner (column F).
any and all advice is more than appreciated!!!!