IF formula help please

Connie Cochran

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 please??

Connie Cochran

Was able to figure it out. It should be

=IF([Site specifics]@row = "Submitter of this form", [Submitters email]@row, IF([Site specifics]@row = "Site coordinator", [Site Coordinator email address]@row, IF([Site specifics]@row = "Day of event coordinator", [Day of event point of contact email address]@row, "")))

Hollie Green

You were missing a couple of @rows try the below

=IF([Site specifics]@row, = “Submitter of this form”, ([Submitters email]@row], IF([Site specifics]@row = “Site coordinator “, [Site Coordinator email address]@row, IF([Site specifics]@row = “Day of event coordinator“, [Day of event point of contact email address]@row))))

Connie Cochran

Thank you Hollie, I copied your formula and I'm still receiving an error #unparseable

Connie Cochran

Was able to figure it out. It should be

=IF([Site specifics]@row = "Submitter of this form", [Submitters email]@row, IF([Site specifics]@row = "Site coordinator", [Site Coordinator email address]@row, IF([Site specifics]@row = "Day of event coordinator", [Day of event point of contact email address]@row, "")))