Create Multiple IF Statement Extracts

Hi.

I'm trying to create an if statement within the "CountyCO" column that pulls in the value where a value is visible from the 3 listed columns (AZ, Counties, DE Counties, DC County). If I write a single IF statement for DE Counties, the value is pulled (=IF([DE Counties]@row = "", "", [DE Counties]@row )) but when I attempt to pull multiple columns, I receive an UNPARSEABLE error (=IF([DE Counties]@row = "", "", [DE Counties]@row ), ), IF([AZ Counties]@row = "", "", [AZ Counties]@row )). I have it set up where an end user can only select one county and the CountyCo will show the selected value. Can you help me to design an IF statement to pull values based on the column where it Is Not Null?

Find more posts tagged with

Accepted answers

Bruce Case

Try something like this:

All comments

Bruce Case

Try something like this:

Bruce Case

Hope this helps.

Charles9937

This works great for me. Thank you so much, Bruce!

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.