Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 months ago
Solved

Contain Word

Hi can someone help me on my calculated column, If the column Name contain SCREW then 0 if not blank Name Result SILICON RTV SEALANT 75 GM TUBE   BLT HEX,A1082-UNS S32760,UNC,5...
Need Help
  • pallavi_r's avatar
    pallavi_r
    2 months ago

    Hi AllanBerces 

     

    Please find the code below to get the expected output.

    Corrected Expected Result =
    IF(
        CONTAINSSTRING('Inventory Data'[Name], "SCREW"),
        0,
        BLANK()
    )
     

     

    If this post helps, please accept this as a solution. Appreciate your kudos.

    Thanks,
    Pallavi

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 months ago

Hi,

Do you want to see 1 if both those words are available in the cell or do you want a 1 if anyone of those is available?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 months ago

    Try this

    =IF(OR(CONTAINSSTRING('Inventory Data'[Name], "SCREW"),CONTAINSSTRING('Inventory Data'[Name], "SILICON)),0,BLANK())