IF Contains Statement with 2 conditions

Question

hi,

i am trying to  use data from two different columns to create a new column but not sure if using IF "Contain" is the best way. Can also use = but i think the issue i'm having is with reading the values in both columns.

Here is what i have so far:

IF CONTAINS ([Address City],'Atlanta') and  and ([Org Level] = "CCB" THEN "Atlanta-CCB"

However, data preview is showing as Null.

Thanks

KamenRider · Answer

Hi @dattina2287

If you are considering multiple records with different options, below is the formula as an example.

regards,

Kamen

gjjadhao · Answer

@dattina2287

Actually, Solution by @ShankerV  should work.

IF CONTAINS([Address City],'Atlanta') and  [Org Level] = "CCB"

THEN "Atlanta-CCB"

ELSE Please fill your

ENDIF

philipmannering · Answer

Hi @dattina2287. Did you manage to solve your issue?