5 Replies Latest reply on Oct 5, 2018 11:54 AM by Sriram Chandra

    check multiple sub strings in a string

    Sriram Chandra

      Hi.

       

      I am trying to write a formula with CONTAINS

      IF [Description]  contains only 'Call' then return 'C'

      ELSEIF [Description] contains only 'Email' then return 'E'

      ELSEIF [Description] contains both 'Call' and 'Email' then return 'B'

      else [Decsription] contains neither words then return 'B'

      end

       

      thanks

      sriram