You need to sign in to do that
Don't have an account?
Aaliya 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.
IF(CASE(X3rd_Party_Or_TB__c, "3rdParty"), "ListPrice__c")
The formula is not working.
You don't need a CASE function when you have to check just one value. Your formula will be like this.
Note that you can use either ISPICKVAL() or TEXT() function with picklist fields.
Kindly mark it as an answer if that works
All Answers
You don't need a CASE function when you have to check just one value. Your formula will be like this.
Note that you can use either ISPICKVAL() or TEXT() function with picklist fields.
Kindly mark it as an answer if that works