{Urgent} renaming field based on condiion

Hi. I want to replace "None" in GSAP_PLANT_MAPPED column with Y01Q based on the condition that LOC_NM_REMAPPED is CHATTANOOGA, TN-LINCOLN TERMINAL. i am using formula tool where I used below expression IF [LOC_NM_REMAPPED]= "CHATTANOOGA, TN-LINCOLN TERMINAL" && [GSAP_PLANT_MAPPED]="None" THEN [GSAP_PLANT_MAPPED]="Y01Q" ELSE [GSAP_PLANT_MAPPED] ENDIF

But this is not working. Any help is appreciated. thanks in advance

sample.xlsx

Workflow

Accepted answers

Towers

@AnanditaShankar

Heres one way

solution.yxmd

All comments

Heres one way

@AnanditaShankar check your IF statement:

Your logic is all correct, you just need to understand that after the THEN statement, you don't need to tell it: Column = Value. Just write the value you want to fill in, it understands already what column it is working on because you tell it here:

i.e:

IF [LOC_NM_REMAPPED]= "CHATTANOOGA, TN-LINCOLN TERMINAL" && [GSAP_PLANT_MAPPED]="None" THEN "Y01Q" ELSE [GSAP_PLANT_MAPPED] ENDIF

logic_help.yxmd

AnanditaShankar

Thanks . It worked

AnanditaShankar

Thank you @BS_THE_ANALYST @Towers

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703