If condition

[mmustkee]

Hi team,

I am receiving an error while applying if formula. I want if my reason column is = ACCEPTED, Offered, Permit, Asked, Given, shared, added, Taken then amt column should be '0' else should remain the same.

PFA data and workflow

Thanks,

Mohamamd Mustkeem

[Emil_Kos · Accepted solution]

Hi @mmustkee,

I have updated your workflow.

I also made some changes in the formula to make it cleaner:

if [Reason] IN ('ACCEPTED' ,'Offered','Permit','Asked') THEN 0 else [Amt] ENDIF

[Assaf_m · Accepted solution]

Hi @mmustkee 

Check attached solution

let me know if it works for you

[mmustkee]

Great Help.

That worked for me.

[mmustkee]

Yes, Asaf it worked for me.

Thanks,

Mohammad Mustkeem