-
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 Marketing Cloud Implementation Guide
Table of Contents Introduction to Salesforce Marketing Cloud (SFMC) Key Features of Salesforce Marketing Cloud Reasons to Adopt Marketing Cloud for Your Business Salesforce Marketing…
Streamline Product Roadmap through Salesforce Service Cloud and Jira Integration
Being a product manager has its perks, but the job also has its challenges. Most of the time goes into product road-mapping and coordinating with…
Learn All About the Report Types in Salesforce
A report is a list of records that meet certain criteria. These records are visualized as a table that can be filtered or grouped based on any field.…
Popular Salesforce Videos
Salesforce Nonprofit Success Pack Implementation Guide
There are so many things to consider when using Salesforce Nonprofit Success Pack for your nonprofit organization that it can be tricky to know where…
What Is Salesforce and Why Is It So Good?
Salesforce is by far the most popular CRM tool for sales, support, and marketing teams worldwide. But what exactly is a CRM and why do…
Salesforce Developer Tools and Productivity
Kevin Poorman shows how you can use Salesforce Developer Tools and how you can unlock developer productivity. Watch this video to learn more.
