-
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
What is Salesforce Financial Services?
If you work in the financial sector and you like Salesforce as much as we do, it’s likely you’ve heard of the Financial Services Cloud.…
Custom Metadata Types: Your Recipe for API Key Security
Imagine we are running a top-secret sandwich joint, and we've got the most delicious secret sauce recipe that's known to humankind. Now, we don’t want…
Salesforce Data Migration: Best Practices and Tips
Migrating data to Salesforce is a crucial step for businesses transitioning from legacy systems or consolidating multiple data sources into one powerful CRM. Done right,…
Popular Salesforce Videos
Salesforce Training Videos - Discussion on Admin Concepts
A Salesforce Admin is a business leader, deeply knowledgeable about how their company operates, intertwined in making all departments successful through process automations, and thus,…
Forecast Accurately With Collaborative Forecasts in Salesforce Lightning Experience
Learn how to use Collaborative Forecasts to predict your team’s sales and take advantage of cumulative rollups, forecast adjustments, territory forecasts, forecast sharing, and quota…
Salesforce Web-to-Case in under 5 Minutes
we'll see how to make a Salesforce Web-to-Case form quickly and easily, and how to embed it in our Word press website. This whole process…
Popular Salesforce Infographics
How to Handle Failed Salesforce AppExchange Security Review?
Common reasons for a ‘FAILED’ Salesforce AppExchange Security Review The most common reasons for failing a Salesforce AppExchange security review can vary, but they often…
Benefits of Integrating Tableau with Salesforce
Tableau Integration with Salesforce helps businesses gain a multitude of advantages. The true power of Salesforce CRM is felt only when business users can analyze…
Selecting the Ideal Salesforce Managed Service Provider
Explore our engaging infographic, offering guidance on choosing the perfect Salesforce Managed Service Provider to maximize your Salesforce investment. Explore key factors to consider when…