Conditional Statement with "Contains" or Starts With Instead of "="

Hi there all,

Is it possible to write a conditional statement within the same column that uses a "Contains", "Starts with", "Does not Include" instead of just equals or does not equal?

here is what i would like to happen

IF [Queue Name] Contains (or starts with) "+1" THEN "External Call"
ELSEIF [Queue Name] Is NULL THEN "Undetermined Call"
ELSE "Internal Call"
ENDIF

If not possible, i know that i can try to use a filter tool to separate them out to additional columns, but i am trying to avoid that

Thanks so much

Preparation

Accepted answers

MarqueeCrew

please show a screen print of you formula configuration.

OUTPUT COLUMN = ?

Data Type = ?

I tried this and got good results.

Cheers,

Mark

All comments

MarqueeCrew

Absolutely!

IF Contains([Queue Name], "+1")  THEN "External Call"
ELSEIF IsNull([Queue Name]) THEN "Undetermined Call"
Else "Internal Call"
Endif

Cheers,

Mark

alphabex18

I appreciate the quick response, however, all the results display "Internal Call" regardless of the type.

FYI - currently the data type selection is V_String, which i changed at the beginning of the workflow from "Double" (the field contains names or phone numbers). maybe that plays a part in why its not running as expected.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703