-
Getting a ‘syntax error’ error message when attempting to use this formula in Salesforce?
I am getting a 'syntax error' error message when attempting to use this formula as part of a workflow rule criteria. I have double-checked the field names are all correct. Can you tell me where I might going wrong?
AND (
NOT(ISPICKVAL(Payment_Detail__c, "Card")),
Days_Send__c = false,
ISPICKVAL(StageName, "Closed Won"),
NOT(Sector__c, "Customer 2"),
NOT(Product__c, "Customer 2"),
Account.Locale = "UK",
NOT((OR(RecordType.Name != "Customer",RecordType.Name != "Customer 2"),
NOT(Prime_Account__c != "TotalCo")
)-
This discussion was modified 5 years, 2 months ago by
Deepak.
-
This discussion was modified 5 years, 2 months ago by
Forcetalks.
-
This discussion was modified 5 years, 2 months ago by Forcetalks.
-
This discussion was modified 5 years, 2 months ago by
-
1 Reply
-
Hi Deepak,
Looks like you're just missing some closing parenthesis on your second to last line
NOT((OR(RecordType.Name != "Customer",RecordType.Name != "Customer 2"),
should be
NOT((OR(RecordType.Name != "Customer",RecordType.Name != "Customer 2"))),
to be syntactically correct.
Log In to reply.
Popular Salesforce Blogs
Salesforce for Energy and Utility Sector for Adapting to New Customer Expectations
Energy and utility companies are known to have contingency plans to remain stable in any uncertain situation. And that’s where digitization has helped such companies…
Idea Management on Experience Cloud: Transforming Business Innovation
In today's fast-paced and highly competitive business landscape, innovation is paramount to staying relevant and thriving. Continuously generating fresh and inventive ideas is essential for…
How to Use "WORKBENCH" with Salesforce!
Workbench is a tool designed for administrators and developers to connect with Salesforce organizations. Salesforce Workbench provides support for the Force.com Partner, Bulk, Rest, Streaming,…
Popular Salesforce Videos
Apex Classes and Apex Triggers in Salesforce
In this video, Salesforce developer Artem will demonstrate real-world applications of both Apex classes and triggers with practical business scenarios. Apex classes and Apex triggers…
Allies Unite at Dreamforce 2019! Datafam march to trailblazers, Drumrolls!
mid laughter and boisterous conversations at Dreamforest, Datafam - the Tableau workforce - turned all heads with a remarkable entry marked with riotous sounds and…
The Significance Of Salesforce Commerce Cloud and Its Features
Commerce Cloud - an all-in-one unified e-commerce platform pronounced to be amongst the leading commerce solutions of today's time. We are a Salesforce commerce cloud…
