1 2 Previous Next 24 Replies Latest reply on Jul 25, 2017 12:52 AM by Michael Simons

    IF [User] CONTAINS any of these 2500 Strings....

    Michael Simons

      Hey All,

       

      I have a list of users, and I also have a list of 2500 banned words/phrases. I am able to creat a calculated field IF/CONTAINS/OR/OR/OR/THEN/ELSE/END however when I populate that formula with the 2500 different OR's it tells me its too complex.

       

      Is there a sophisticated way to say:

       

      IF CONTAINS([User],[BannedWords]) THEN......

       

      THANKS

        1 2 Previous Next