Am I missing something? I'm trying to use a nested IF statement to check three cells in different columns for value. There should only be value in one of the 3 cells. Once it finds the the cell with the value, set column Type with value. Here are the columns: * Type (Number/Text) - Cell with the IF Statement * Document (Multiple value drop-down) * WIFI (Multiple value drop-down) * Computer (Multiple value drop-down) IF Statement =IF(NOT(ISBLANK([Document]@row)), [Document]@row, "", IF(NOT(ISBLANK([WIFI]@row)), [WIFI]@row, "", IF(NOT(ISBLANK([Computer]@row)), [Computer]@row, "")))

Need help with nested IF Statement

Am I missing something?

I'm trying to use a nested IF statement to check three cells in different columns for value. There should only be value in one of the 3 cells. Once it finds the the cell with the value, set column Type with value.

Here are the columns:

Type (Number/Text) - Cell with the IF Statement
Document (Multiple value drop-down)
WIFI (Multiple value drop-down)
Computer (Multiple value drop-down)

IF Statement

=IF(NOT(ISBLANK([Document]@row)), [Document]@row, "", IF(NOT(ISBLANK([WIFI]@row)), [WIFI]@row, "", IF(NOT(ISBLANK([Computer]@row)), [Computer]@row, "")))

Find more posts tagged with

Accepted answers

MCorbin

You had your "" at the end of each if statement, which meant it never goes on to the next.

Try this:

=IF(NOT(ISBLANK(Document@row)), Document@row, IF(NOT(ISBLANK(Wifi@row)), Wifi@row, IF(NOT(ISBLANK(Computer@row)), Computer@row, "")))

All comments

MCorbin

You had your "" at the end of each if statement, which meant it never goes on to the next.

Try this:

=IF(NOT(ISBLANK(Document@row)), Document@row, IF(NOT(ISBLANK(Wifi@row)), Wifi@row, IF(NOT(ISBLANK(Computer@row)), Computer@row, "")))

Tommy Moua

MCorbin,

Thank you for the suggestion. Unfortunately, that didn't work. I get error, #UNPARSEABLE.

Tommy Moua

MCorbin,

Got it working. Needed brackets for another column with space between the column name.

Thank you for your help.

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.