-
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 the Search Box In Aura Component? | The Developer Guide
A search box in an Aura component is a user interface element that allows users to input text and search for relevant information within the…
4 Types of Salesforce Community Licenses
The foremost challenge that organizations face today is to provide excellent customer service to their customers and partners and include it in their daily processes.…
An Overview of Salesforce Einstein Analytics
In this top blog on Salesforce, we will be discussing Salesforce Einstein Analytics and what it is, how it works, and more. Salesforce Einstein Analytics…
Popular Salesforce Videos
Salesforce Interview Questions and Answers | 70 Salesforce Interview Questions for the Beginners
In this video, Interesting data explains 70 Salesforce Interview Questions for Beginners. All the interview questions have been divided into the following important areas of…
Use cases Automation UiPath with Salesforce
The following video demonstrates a UiPath Robot automatically populating Salesforce using data read from an Excel spreadsheet....imagine how UiPath Robots could accelerate your Salesforce activities.…
Custom Aura Feed Component | forceChatter:feed | Chatter in #Salesforce | Salesforce Tutorials
In this vlog I will create a custom aura feed component with two picklists to select Group and then based on the Group selection, select…
Popular Salesforce Infographics
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…
MVP Magic for Building Success Step by Step
Embark on a strategic journey, defining vision, iterating with user feedback, and scaling, as MVP development unfolds step by step, ensuring enduring product excellence and…
5 Advantages of Using The Salesforce Data Migration Tool in Your Organization
Advantages Of Using The Salesforce CRM Data Migration Services In Your Company are: Fast migration process Repetitive deployment Suitable for both novice and advanced Salesforce…