3 Replies Latest reply on Dec 3, 2018 5:54 PM by lawrence napier

    CONTAINS() FILTER RETURNING UNWANTED RECORDS

    lawrence napier

      I am trying to set up a filter for records with the string "request form" in the [description] field.

       

      When I enter ....

       

      CONTAINS ([description], "request form")

       

      ....in the Filter Condition Tab as a formula, I get records returned such as....

       

      john's request form

      request form #2

      request form

       

      .... I don't just get the records that just have "request form" in the [description] field.

       

      How can I only return records in the [description] field that only have "request form" entered?