0

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"))))
Improve this question
4
  • your formula looks correct. try to remove start and end bracket
    – Tushar Sharma
    Commented Jun 13, 2017 at 8:45
  • I have removed small bracket from start and end.Still getting same error.
    – Jack vardy
    Commented Jun 13, 2017 at 8:47
  • What is your rule criteria doing, it looks incorrect.
    – Raul
    Commented 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
    Commented Jun 13, 2017 at 9:03

3 Answers 3

Reset to default
0

Check this formula.

OR(!(CONTAINS(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"))))
Improve this answer
2
  • I dont want "contains" on 1st condition. i.e !(CONTAINS(TEXT(PRIORVALUE(Sales_Order_DSR_Status__c)),"Booked"))
    – Jack vardy
    Commented Jun 13, 2017 at 9:05
  • TEXT function has only one parameter. so you can't pass two parameter in TEXT function.
    – Alap Mistry
    Commented Jun 13, 2017 at 9:18
0

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"))))
Improve this answer
0 
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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .