GetFieldSelections more than one value

[#1]

i can't figure out the syntax for using more than one value with the GetFieldSelections function

GetFieldSelections(SECTOR)='CROSSOVER' AND GetFieldSelections(SECTOR)='CROSSOVER UPFRONTS'

i tried this but it doesn't work

any ideas?

[MK_QSL]

TRY

=IF(GetFieldSelections(SECTOR)='CROSSOVER,CROSSOVER UPFRONTS',

     Condition for True,

     Condition for False)

[#3]

Try:

if(SubStringCount(GetFieldSelections(SECTOR,', ',5000),'CROSSOVER')>0 or SubStringCount(GetFieldSelections(SECTOR,', ',5000),'CROSSOVER UPFRONTS')>0,1,0)

With 5000 as your max values (change as needed).