Below is my workflow formula for evaluation.I am getting error saying "Error: Syntax error. Missing ')'"

(OR(!(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c)),"Booked"),(!CONTAINS(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c )),"Complete")),(!CONTAINS(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c )),"Terminated"))))
  • your formula looks correct. try to remove start and end bracket Jun 13, 2017 at 8:45
  • I have removed small bracket from start and end.Still getting same error.
    – Jack vardy
    Jun 13, 2017 at 8:47
  • What is your rule criteria doing, it looks incorrect.
    – Raul
    Jun 13, 2017 at 8:50
  • My rule criteria says that previous value of sales order status field should not equals "booked" or previous value of sales order status field should not contains "Complete" word in picklist or previous value of sales order status field should not contain "terminated" word in picklist. sales order status field is picklist field.
    – Jack vardy
    Jun 13, 2017 at 9:03

3 Answers 3


Check this formula.

  • I dont want "contains" on 1st condition. i.e !(CONTAINS(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c)),"Booked"))
    – Jack vardy
    Jun 13, 2017 at 9:05
  • TEXT function has only one parameter. so you can't pass two parameter in TEXT function. Jun 13, 2017 at 9:18

Try This:

OR(NOT(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c)),"Booked"),(NOT(CONTAINS(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c )),"Complete"))),(NOT(CONTAINS(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c )),"Terminated"))))
OR(!(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c))="Booked"),!CONTAINS(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c )),"Complete"),!CONTAINS(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c )),"Terminated"))

This worked fine

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.