Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
TRY
=IF(GetFieldSelections(SECTOR)='CROSSOVER,CROSSOVER UPFRONTS',
Condition for True,
Condition for False)
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).