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

Find more posts tagged with

Accepted answers

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, "")))

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.