+ Start a Discussion
Aaliya YusufzaiAaliya Yusufzai 

Picklist Formula Field

I am looking at creating a formula currency field to populate the field "List Price" only if a value from a picklist field is selected:
IF(CASE(X3rd_Party_Or_TB__c, "3rdParty"), "ListPrice__c")

The formula is not working. 
Best Answer chosen by Aaliya Yusufzai
Akhil AnilAkhil Anil
Hi Aaliya,

You don't need a CASE function when you have to check just one value. Your formula will be like this.
 
IF(
TEXT(X3rd_Party_Or_TB__c) = "3rdParty",
ListPrice__c,
NULL
)

Note that you can use either ISPICKVAL() or TEXT() function with picklist fields.

Kindly mark it as an answer if that works

All Answers

Akhil AnilAkhil Anil
Hi Aaliya,

You don't need a CASE function when you have to check just one value. Your formula will be like this.
 
IF(
TEXT(X3rd_Party_Or_TB__c) = "3rdParty",
ListPrice__c,
NULL
)

Note that you can use either ISPICKVAL() or TEXT() function with picklist fields.

Kindly mark it as an answer if that works
This was selected as the best answer
Aaliya YusufzaiAaliya Yusufzai
Thank you Akhil!