Issues with IF formula

KTM

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!

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

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.