Creating a Field off of two conditions

[#1]

Hi I was wondering if it is possible to create  a Field where the user can choose out of two options using these statements

IF(WildMatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*'),'Billable')

IF(WildMatch(MsgCategories,'*NONBILLABLE*'),'NonBillable')

[sasikanth]

Hi

try some thing like this

IF(WildMatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*') and  MsgCategories-=' NONBILLABLE' ,

'Billable)

[#3]

I need IF(WildMatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*'),'Billable')  To show up as Billable  and IF(WildMatch(MsgCategories,'*NONBILLABLE*'),'NonBillable')  AS NonBillable

[sasikanth]

IF(WildMatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*') and 

MsgCategories-=' NONBILLABLE' ,'Billable)

it will gives Billable only

[#5]

I need IF(WildMatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*'),'Billable')  To show up as Billable  and IF(WildMatch(MsgCategories,'*NONBILLABLE*'),'NonBillable') To show up as NonBillable

[#6 · Accepted solution]

In Script level try this,

Load

       IF(Wildmatch(MsgCategories,'BILLABLE','*;BILLABLE','BILLABLE;*'),'Billable',

         if(WildMatch(MsgCategories,'*NONBILLABLE*'),'NonBillable')) as Flag

Your flag field consist of two field value  Billable & NonBillable ...

Hope it is match with your requirment.

[#7]

Thank You so much, It seems like it is working perfectly, however there are messages that can be both billable and non billable, it will not pick that up correct? it will show up as billable only It seems.