-
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
Top Picks Service Cloud Features, Salesforce Winter '22 Release
Every year Salesforce release features get bigger and better. This year is nothing short of new exciting features. Salesforce released its Winter ‘22 release features…
Automate Call Logs Using RingCentral for Salesforce
Hi All, RingCentral one way solution for calling from Salesforce. This app is available on AppExchange, you just need to install it and make some administrator…
Popular Salesforce Videos
How To Create A Case Assignment Rule In Salesforce
Learn all about how to create Case Assignment rules. In this video, the following points will be covered - 1. Introduction To Case Assignment Rule…
Simple Salesforce to Salesforce Data Migration Step by Step | 100% Salesforce Native App
How to Migrate Salesforce Data? Create Template: As the name suggests, this is just like a sandbox template; these templates store template lines & various…
Salesforce Admin 201 Training for Beginners: Different Types of Relationship in Salesforce
The Salesforce Certified Administrator program is designed for individuals who have experience as a Salesforce administrator. The program encompasses the breadth of applications, the features…
Popular Salesforce Infographics
The Working Of Salesforce CRM
Salesforce CRM is considered as the #1 CRM in the market. It has the ability to manage customer interactions of an organization through several methods.…
How Salesforce is Beneficial For Your Business
There is a saying frequently heard many times which is “ Customer is a King”. So, a business needs to do everything to satisfy the…
Benefits of Using WhatsApp For Better Customer Engagement
WhatsApp makes businesses more interactive and reliable. Customers can directly connect with a company, clear their doubts, and leverage a connected experience. 5 million business…