#UNPARSEABLE for Column "IF" Formula

I get an #UNPARSEABLE error for the following formula and am not sure what I'm doing wrong:

=if([Destination]@row] = [Source]@row, [Destination ID #]@row, "")

Where the destination = source, the destination ID should be entered. Otherwise, I want to leave the cell blank so that someone can manually enter the ID #.

Find more posts tagged with

Formulas

Accepted answers

kss5229

I just saw the error: an erroneous bracket was after "[Destination]@row" It should be:

=if([Destination]@row = [Source]@row, [Destination ID #]@row, "")

All comments

Alan P.

Do you have a screenshot of the the column headings, and the field which contains the formula?

kss5229

I just saw the error: an erroneous bracket was after "[Destination]@row" It should be:

=if([Destination]@row = [Source]@row, [Destination ID #]@row, "")

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.