Issues with IF formula

Issue we need to resolve: The scope of work gets filled out by the client. The client has old information regarding location. In this example that location is 1-X-Kt/4.5. This location has been updated to 1-X-Kt/3.5 because of a remodel. We want the location to change to the updated location in a new column.

Desired outcome: If Scope of Work column contains "1-X-Kt/4.5", put "1-X-Kt/3.5" in the Scope Notification column.

I put the formula =IF([Scope of Work]@row = "1-X-Kt/4.5", 1-X-Kt/3.5) in the Scope Notification column, but I am receiving #Unparseable error.

Am I using the wrong formula for our desired outcome?

Thanks in advance!

Find more posts tagged with

Accepted answers

DKazatsky2

@KTM,

I completely missed that requirement the first time. Try this one.

=IF(CONTAINS("1-X-Kt/4.5", [Scope of Work]@row), "1-X-Kt/3.5")

All comments

DKazatsky2

Hi @KTM,

Try putting quotes around the value you want in the cell.

=IF([Scope of Work]@row = "1-X-Kt/4.5","1-X-Kt/3.5")

Hope this helps,

Dave

KTM

Hi Dave,

Thanks so much for your response.

That formula does work if the only value in the Scope of Work is "1-X-Kt/4.5" (shown in row 2 below), but it leaves the cell blank if it contains other verbiage (shown in row 1 below).

Do you know what the formula would be if the Scope of Work contains additional data?

Thanks again for your help, we're getting closer than I was before!

DKazatsky2

@KTM,

I completely missed that requirement the first time. Try this one.

=IF(CONTAINS("1-X-Kt/4.5", [Scope of Work]@row), "1-X-Kt/3.5")

KTM

@DKazatsky2 - That worked perfectly! Thanks so much 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.