-
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
How to Make Your Fundraising Campaigns More Effective Through Salesforce
Salesforce has earned its place as one of the most intuitive and comprehensive CRM solutions in the market today that’s been used by many businesses.…
Learn Salesforce Einstein – Chapter 4 (How to check API Usage)
How to check API Usage You can see this page if you have uploaded the key using these steps. You see below sections here: 1. API…
Validation Rules in Salesforce | All You Need to Know
Validation rules in Salesforce are used to enforce data quality by ensuring that data entered into Salesforce meets certain standards. They are used to validate…
Popular Salesforce Videos
How to Create a File Location in Salesforce Marketing Cloud
Cameron Robert shows how to use PuttyGen to generate and create an SSH Key for SFTP usage in Salesforce Marketing Cloud, then how to create…
What are lookup filters in Salesforce?
In this video, we will leaarn about Lookup Filters in Salesforce by dividing this topic into 4 basic points, which are: 1. What is a…
See what amazing things Cauzali can add to your Salesforce solution - without code
Use Cauzali to add functionality to your Salesforce community solution. In this video, we have a focus on Salesforce Financial Service Cloud, but Cauzali works…
