-
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
5 Things You Need to Know about Salesforce Commerce Cloud
Salesforce Commerce Cloud, formerly known as Demandware, is a robust and scalable cloud-based platform designed to empower businesses with advanced e-commerce capabilities. As an industry-leading…
Salesforce: A Brief History And What The Future Holds
If you have even a passing interest in Salesforce and use SFDC tools at work, some knowledge of how the Salesforce platforms came to be…
Integrating Single Salesforce Org With Multiple Jira Instances with Sinergify
Why the need for different Jira instances within the same organization? As we all know, Salesforce is a CRM platform and organizations use it for…
Popular Salesforce Videos
Best Chrome Extensions for Salesforce
These are the best FREE Chrome Extensions to use with Salesforce. Installing Chrome extensions is the easiest way to enhance your experience on the Salesforce…
Guided Setup with Salesforce Field Service Administration - Webinar Recording
Salesforce Field Service is a complete, end-to-end solution for customer service in the field. Salesforce Field Service brings together customers, employees, and products on a…
Salesforce Lightning User Tips and Tricks Spring 2023
SalesPath Corporation has created a video explaining tips and tricks that every Salesforce user will find helpful in order to increase productivity. This video also…
Popular Salesforce Infographics
How to start your career In Salesforce?
Considering a career in Salesforce is a good choice for IT professionals looking to give a new boost to their career. Salesforce is a new…
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…
What is Salesforce Architecture?
Have you ever wondered that what is so special about Salesforce? How does it manage to accomplish so much in such a less time? Well,…
