Hi, Im trying to create a formula that all cells within column M on sheet 3 contains. Once the word "Yes" is inputted an email is sent to a specific person.

Thanks in advance.