Writing an If statement identifying multiple values

[Adam_B]

Hello, 

I have an IF statement that I need to identify multiple values in one field and change those Contract types to a different name.  Here is what I have as the formula:

If [Contract Id] = "CW2293919","CW2290258","CW2290427",“CW2291285”,“CW2290240”,“CW2290769”,"CW2291040",“CW2291294”,“CW2291326”,“CW2291328”,“CW2291331”,“CW2291425”,“CW2291954”,“CW2291956”,“CW2292754”,“CW2293279”,“CW2293387”,“CW2293399”,“CW2293404”,“CW2293412”,“CW2293433”,“CW2293741”,“CW2294151”,“CW2294311”,
“CW2297164”
Then [Contract Type] "Supplier Code of Conduct Agreement" ELSE [Contract Type] ENDIF

However, there is something wrong and I can't figure out why. 

Please help

Thanks

Adam 

[binuacs]

@Adam_B use IN () instead of = in the if statement

[StellaBon]

Instead of using commas, you would need then after each instance followed by ELSEIF Then for each new instance. But I would suggest learning the SWITCH() formula which would work perfectly with your current format of comma delimited string values. Good Luck!

StellaBon

[Adam_B]

@StellaBon @binuacs That didn't seem to work, this is the output:

[DataNath · Accepted solution]

Hey @Adam_B, looks like you also have [Contract Type] left in before your THEN. Try this:

If [Contract Id] IN ("CW2293919","CW2290258","CW2290427",“CW2291285”,“CW2290240”,“CW2290769”,"CW2291040",“CW2291294”,“CW2291326”,“CW2291328”,“CW2291331”,“CW2291425”,“CW2291954”,“CW2291956”,“CW2292754”,“CW2293279”,“CW2293387”,“CW2293399”,“CW2293404”,“CW2293412”,“CW2293433”,“CW2293741”,“CW2294151”,“CW2294311”,
“CW2297164”)
THEN "Supplier Code of Conduct Agreement"
ELSE [Contract Type] ENDIF

[Adam_B]

@DataNath That worked, thank you!

[StellaBon]

I forgot Alteryx could use IN-- In wins!