-
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 -
0 Replies
Log In to reply.
Popular Salesforce Blogs
Instantly Deploy Free COVID-19 Care Response Solution with Global Salesforce Implementation Partner
World leaders and global health care providers are overwhelmed with inbound calls and an amplified number of cases they are receiving each day affected by…
Salesforce Mobile App Development: Integrating Third-Party Apps and Services
Introduction Productivity while on the road is essential in today's hectic work environment. In order to empower its users, Salesforce, a top customer relationship management…
No Code Salesforce and Yesware Integration
Salesforce integration provides a comprehensive perspective of data, allowing for better decision-making based on a thorough knowledge of risks and advantages. It also allows for…
Popular Salesforce Videos
External File Storage for Salesforce | Learning Guide
We demonstrate how to avoid Salesforce's file storage limit by using external files. Read the article and download the sample file. https://dbservices.com/blog/external-file-storage-for-salesforce
Can I Get a Job by Just Learning Salesforce Admin?
In this Video Shrey covered the following questions: 1. Can I get a job by just learning Salesforce Admin? 2. Can you start a career…
Salesforce Development Tutorial - sObjects
It is very easy to learn Salesforce with the world class training tutorial. Training is key for the right knowledge. Those who work as an…
Popular Salesforce Infographics
6 Tips to Evaluate the Right Salesforce QA Vendor
Salesforce is the ultimate customer success platform, which makes it important to choose the right partner for your Salesforce project especially because it governs your…
Enjoy the Salesforce Innovation Management infographic
Without innovation, a company will stay in one place. Without getting ideas from those closest to your product or service - customers, employees, and partners…
Why Do Business Move To Salesforce?
Salesforce Improves Customer Data Quality & Management – One of the core functions of all CRMs is data management about customers. Salesforce delivers in this…