-
How to do multiple if else statements in a formula field?
I have a picklist on my Contracts object, and the possible values are: 'contract type a', 'contract type b, 'contract type n', etc.... I want to setup a formula field where, If 'contract type a' is selected, then the value of the formula field is "x". If 'contract type b' is selected, then the value should be 'y', so on and so forth. If no value is selected, it should be '0'.
I can get one If else to work, but am having trouble adding in the other conditions. Any help is much appreciated!
-
3 Replies
-
Hii Naman,
You can create the formula using nested if-else condition. It would look something like this.
If(ISPICKVAL(Name_Picklist_Field, 'contract type a'),'x',IF(ISPICKVAL(Name_Picklist_Field, 'contract type b'),'y','0')) and so on.
Replace the Name_Picklist_Field with the name of your picklist field api name. This formula works for the text type value.
You can modify it according to your own.
Thanks.
-
I have this scenario:
abc_c (A)+ def_c (West) + ghi_c (Elite) = 90,o00
abc_c (B)+ def_c(MidWest) + ghi_c (Preferred) = 50,000
values in the () are values from a picklist. The custom api fields are picklists which contains various values. Whenever any of these combinations are selected, the final value should be the set value, e.g., 90,000.
What would be the correct syntax to write this up, thanks in advance!
-
Hi Nick,
Here we can use "CASE" Formula function in the formula fields.
CASE(CASE(abc_c, "A","A","B","B","") + CASE(def_c, "West", "West", "MidWest", "MidWest","") + CASE(ghi_c, "Elite","Elite","Preferred","Preferred","") , "AWestElite", 90000, "BMidWestPreferred", 50000,0)
Log In to reply.
Popular Salesforce Blogs
Salesforce Ant Migration Tool - The Complete Guide
Ant Migration Tool is one of the three tools available for Salesforce deployment and it is a totally Java based command line for moving metadata…
Order of Execution in Salesforce
Order of execution in salesforce is like an ABC in Salesforce World, make sure you should understand:- System Validation rule(required field, field format). Before Trigger…
All About Apex Trigger in Salesforce | Learn How to Create a Trigger
Trigger is a piece of code which executes or fired whenever a record is created, edited or deleted. It’s a concept of automation processes and…
Popular Salesforce Videos
Building a Custom UI with Lightning Web Components | Salesforce Tutorial
Lightning Web Components is a modern JavaScript framework that leverages the web standards breakthroughs over the past few years. Watch this session to understand how…
Salesforce Consulting - WHAT YOU NEED TO KNOW
If you're already working as a Salesforce Professional or you're interested in where your Salesforce Career will take you this is for you. This explains…
Salesforce Einstein Activity Capture Guide
Have you ever had issues maintaining accurate, up-to-date information between your Salesforce org and your clients? Einstein Activity Capture is here to work for you…
