5 Replies Latest reply on Mar 15, 2017 11:44 AM by Gerardo Varela

    CONTAINS formula: correctly using

    Dilyana Suleymanova

      this is my data set

       

      LPST 2017 201 01

      LPST 2017 202 01

      LPST 2017 401 01

      LPST 2017 201 01

      LPST 2017 202 01

      LPST 2017 202 01

      LPST 2017 401 01

      LPST 2017 401 01

      LPST 2017 202 01

      LPST 2017 401 01

      LPST 2017 401 02

       

      I would like to group this ID by group with the formula "contains" and say, that

      IF I have  ID, which CONTAINs "201" then it is "Fax

      IF I have ID which CONTAINs "201" then it is "E-Mail"

       

      This is my formula:

       

      if CONTAINS("LPST 2017 201 01","201") then "Fax"

      ELSEIF

      CONTAINS("LPST 2017 401 01", "401") then "Email"

      ELSEIF

       

      END

       

      And this is my result

       

      I have Fax only. How can I fix it? May be I should try it out with other formula?

      If you have any ideas, I would apreciate it.

      Thank you!