2 Replies Latest reply on Mar 1, 2013 9:21 AM by Allison Suarez

    Calculation based on text field

    Allison Suarez

      Good Morning,

      I am trying to create a calculation based on a text field and am having trouble.  Here is the breakdown . . . I want to look in a long text field for a specific value (in this case "PX").  If PX exists i want it to return "Changes" if not, then "No Changes".  The formula I am trying is below but it is not valid.  The error is on the C in contains and is "Expected closing parenthesis for the expression starting and character 4".

       

      IF ([INTERNAL_NOTE] CONTAINS('PX')) THEN 'Changes' ELSE 'No Changes'

       

      Any suggestions?