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 – Tushar Sharma Jun 13 '17 at 8:45
  • I have removed small bracket from start and end.Still getting same error. – Jack vardy Jun 13 '17 at 8:47
  • What is your rule criteria doing, it looks incorrect. – Raul Jun 13 '17 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 '17 at 9:03

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 '17 at 9:05
  • TEXT function has only one parameter. so you can't pass two parameter in TEXT function. – Alap Mistry Jun 13 '17 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.