Three condition with Rule

[ksarker]

Hello, how can i resolve this following issue- If Column A start with 1, Column B =XYZ, Column C=ABC then column D=REV

Column A	Column B	Column C	Column D
145896	XYZ	ABC	N/A
421	KHY	ERT	N/A
1589647	XYZ	ABC	N/A

[ShankerV]

Hi @ksarker

Please use the below in formula tool. 

IF left(tostring([column A]) , 1)="1"

AND [column B] = "XYZ"

AND [column C] = "ABC"

THEN "REV"

ELSE [column D]

ENDIF

[ksarker]

Hi Shanker, thanks for your response but somehow i am getting result "Null" . it didn't resolve my issue :( 

[ShankerV · Accepted solution]

Hi @ksarker 

Please check, I have used the same formula and I could see the expected result.

Can you please share some screenshots to check what went wrong in your workflow.

Many thanks

Shanker V