IF formula help please
I have one column that has a drop down of 3 choices and based on the answer I want to list information in another column. Like if they select "Submitter of this form" I want it to return the information in the "Submitters email" column.
Getting an error and can't see what it is;
=IF([Site specifics]@row, = “Submitter of this form”, ([Submitters email]@row], IF([Site specifics]@row = “Site coordinator “, [Site Coordinator email address], IF([Site specifics]@row = “Day of event coordinator“, [Day of event point of contact email address]))))
Help Article Resources
Check out the Formula Handbook template!