-
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
Solidify Customer Base with Case Management in Salesforce Service Cloud
In today’s digitally-driven and customer-centric world, the traditional methods of extending support have taken a backseat as customers expect new and innovative ways. But, even…
Implementing Data Collection for Impact Evaluations | Salesforce Guide
Implementing a well-developed method for data collection and analysis for whatever type of evaluation is crucial for any business or organization. This is because such…
How to Create AM Chart Using Salesforce Lightning Component?
Hi Friends, When I was learning AM Chart creation in salesforce lighting, I was facing lots of difficulties to implement this and for every AM…
Popular Salesforce Videos
Salesforce Consent Management
Consent Management: Track Customer Consent and Honor Opt-Out Requests. Track your customers' approval for how your company interacts with them. To help you assess your…
Work Your Opportunities and Manage Your Pipeline (Lightning Experience) | Salesforce
In this video, Salesforce Support demonstrates how to work with deals and manage your pipeline in the Salesforce Lightning Experience. With interactive features that help…
Do you need to learn Salesforce Admin & App Builder if you want to become Salesforce developer ?
5 reasons why you need to learn the Salesforce Admin and App Builder even if you want to become or you are a Salesforce Developer.…