-
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, 5 months ago by
Deepak.
-
This discussion was modified 5 years, 5 months ago by
Forcetalks.
-
This discussion was modified 5 years, 5 months ago by Forcetalks.
-
This discussion was modified 5 years, 5 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 Apex to Flow - For Starters with a Very Simple Example
APEX Code Into Flow We have many times heard, implemented and worked with Flows. There are many sites and videos available which would give you…
6 Ways to Improve Salesforce Release Management
Salesforce was initially planned as a CRM. Be that as it may, it's become a mainstream improvement stage because of its natural usefulness. Salesforce uses…
How to Manage Closed-Lost Leads in Salesforce that Comes Back Again
As a salesperson, you want to successfully convert every lead you get but the task is actually a tall order. Based on initial interaction, you…
Popular Salesforce Videos
Enhance Multi-Select Picklist Functionality With Flows to Increase Reportability | Salesforce
Multi-select picklists are AMAZING but have some MAJOR downsides. Do you like the functionality of muti-selects but hate reporting on them? Does the easy user…
See what amazing things Cauzali can add to your Salesforce solution - without code
Use Cauzali to add functionality to your Salesforce community solution. In this video, we have a focus on Salesforce Financial Service Cloud, but Cauzali works…
Salesforce Administrator and Developer Training | Salesforce Training Videos
This Salesforce Training video is a demo of how the live online instructor-led classes take place after you enroll for the Online Classroom. All training…