Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
5 years ago
Solved

help with Search function

Hi Team,   below is my coloumn       and calculated coloumn status = IF(SEARCH("NoNoNo",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0,"In Markets, Other SMU"   Curr...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    vjnvinod 

    status =
IF(
  SEARCH("NoNoNo",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0 &&
    SEARCH("CBS",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0,
  "In Markets, Other SMU"
)