-
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, 3 months ago by
Deepak.
-
This discussion was modified 5 years, 3 months ago by
Forcetalks.
-
This discussion was modified 5 years, 3 months ago by Forcetalks.
-
This discussion was modified 5 years, 3 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
Trigger to blacklist domain name for sending email
You now have an awesome Salesforce instance that you use for your sales and marketing purposes. Your instance sends hundreds of mails weekly, many of…
Tableau Now Powers Salesforce Genie Customer Data Cloud
Salesforce Genie Customer Data Cloud is a powerful platform that helps businesses unlock the value of their customer data. Now powered by Tableau, Salesforce Genie…
The 8 Elements Your Training and User Adoption Plan Must Have | Salesforce Tips
Your company just made a large investment and spent a whole lot of time implementing Salesforce into your organization, and now the time has come…
Popular Salesforce Videos
How to Become a Certified Salesforce Admin
It is predicted there will be 1.9m new Salesforce job openings by 2020. Consultants thinking of a career in IT should consider training in cloud…
Searching for Records In Salesforce
You can search globally across all of Salesforce for matching records to your search term. Or you can search within a specific object. You will…
Salesforce Einstein Keynote: Meet Your Smart CRM Assistant
Salesforce Einstein is your smart CRM assistant, making your employees smarter and your customers happier. With Einstein, everyone has an AI-powered assistant to help them…
