if else replacement

[sriniprad08]

Hi All,

I need help. I have simple query please find below

IF [PARTYADNO] = "44434" THEN ([PARTYADNO]="434334"
AND [PARTYPARTYADID] = "zghh,ke wea") ELSE [PARTYADNO] ENDIF

So formula should replace 44434 with 434334  and also replace PARTYPARTYADID field with zghh,ke wea. 

Thanks

SR

[Qiu · Accepted solution]

@sriniprad08 

I think we can only update one column at a time.

[Emil_Kos · Accepted solution]

Hi @sriniprad08,

I have created a workflow for you. I think you actually need two formula to make it work:

The output:

[sriniprad08]

Thank you @Qiu very helpful

[sriniprad08]

Thank you @Emil_Kos  very useful.