I am attempting to create a sign in sheet for students when they are sent to a "calming" room. The idea is that when they reach the room, they enter their name and select their teacher's name from a drop down list.
I am using Form-mule to automatically send an email to the teacher the student selected saying that they checked into the calming room. However, Form-mule only allows you to set up 15 templates and as we have more than 15 teachers and I cannot expect a 3rd grader to be able to remember their teachers email address, I was hoping I could create a nested
IF statement which will compare the teachers name the student selected and to enter an email address in a separate column of the Google Sheet.
The formula I have been using is:
=IF(D2 = “Mrs.Winehouse”, ”firstname.lastname@example.org”, IF(D2 = ”Billie Eilish”, ”email@example.com”, IF(D2 = ”Jay Cutler”, ”firstname.lastname@example.org”,“”)))
D2 is the row of the Google Sheet where the Teacher Name info populates.
Unfortunately, I keep receiving a parse error.