-
Formula fields help please
Hello all,
I am need with help with my formula, I want it to do a calculation based on a criteria using formula fields this how my formula looks:
IF(
IF( ISBLANK( npsp__Primary_Contact__c ) , value_if_true, value_if_false),
IF( Payment_method__c NOT( CONTAINS(paypal, debit card, mastercard, stewardship, work for good ) ) ,
IF( StageName CONTAINS(post, secured) ,
IF( Contact__r.Funding__c , yes)
Amount - ( Amount * 0.8)
))))
Any help on how I can this working please
If this criteria is met:
- primary contact is not blank a field
- payment method (picklist field) is not paypal, debit card, mastercard, stewardship, work for good
- stage (picklist field) is either posted or secured
- funding (picklist field) equals yes
If criteria is met I would want this to be calculated Amount - ( Amount * 0.8)
Any help would be appreciated.
Many Thanks
Log In to reply.
Popular Salesforce Blogs
How to overcome Red Flags that indicate harm to your digital strategy?
Choosing CRM is life-changing, and this is not a joke. The way a software adjusts to your customer management approach; its ability to scale and…
Upload Files as Attachment using Apex Salesforce
Files replaced Attachments in Salesforce. Now any type of document upload becomes part of Files/Content in Salesforce. With all the other advantages over Attachments, the…
Popular Salesforce Videos
In App Guidance | Salesforce Tutotial
In this video, we take a look at one of the new features from the Salesforce Summer '19 release - In-App Guidance. We explain what…
How Much I Earn as a Salesforce Consultant!
In this video, Adam Foyston gives a detailed look at the earnings of Salesforce consultants, how they compare to the earnings of Salesforce admins, and…
Salesforce Developer No Code and Code - Extended Version
Here you will find a showcase of new technologies, tools, product news, and tutorials from Salesforce experts. Learn to build, automate, and scale on the…
Popular Salesforce Infographics
The Salesforce Lightning Platform for Employee Engagement: Key Findings
Salesforce provides a system of engagement across the entire employee lifecycle that enables organizations to connect multiple back-end systems of record with one system of…
Salesforce CRM Integration With External Systems
Salesforce integration is one of the most important aspects of Salesforce services. It allows businesses to keep their Salesforce environment up and running. Integration Features…
Best Ways to Bring Customers and Companies Closer With Salesforce
Salesforce is World’s #1 CRM It works as a single source of truth It delivers fast time to value It is a scalable & flexible…