[SalesForce] Error: Syntax error. Missing ‘)’

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"))))

Best Answer

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"))))

Related Solutions

[SalesForce] inputText Syntax Error – missing ‘)’

Update

Move your binary operators into a 'rendered' attribute to determine which type of input you want to show, than flip the variables accordingly:

<apex:inputText id="daysToCount" style="width: 30px;" value=" TEXT(prefs.Recent_Interaction_Days__c)}" rendered="{!IF(prefs != null && prefs.Recent_Interaction_Days__c != null)}"/>
<apex:inputText id="daysToCount" style="width: 30px;" value="30" rendered="{!IF(prefs != null && prefs.Recent_Interaction_Days__c == null)}"/>

[SalesForce] Formula Error: Syntax error. Extra ‘,’

The start Bracket ( of IF is missing. Try this one:-

IF(
     (TODAY() > CloseDate && TEXT(StageName)='Donation Likely')
     || 
     (TODAY() > CloseDate && TEXT(StageName)='Donation Prospecting'),
     "Past Due",
     "Expecting"
)

Best Answer

Related Solutions

[SalesForce] inputText Syntax Error – missing ‘)’

[SalesForce] Formula Error: Syntax error. Extra ‘,’

Related Topic