Salesforce | How to use If condition with picklist in formula field? - Forcetalks

Tagged: If Condition, IF ISPICKVAL Formula, Picklist, Salesforce Fields, Salesforce Formula Field, Salesforce sObject

Salesforce® Discussions

How to use If condition with picklist in formula field?

Posted by Anjali on August 3, 2018 at 1:36 PM

How to use If condition with picklist in formula field?

Avnish Yadav replied 7 years, 9 months ago 2 Members · 1 Reply
1 Reply

Avnish Yadav

Member
August 6, 2018 at 5:04 AM

Hello Anjali,

You can use ISPICKVAL() with IF condition.

Example-

IF(ISPICKVAL(API__c1, “Option1”), Sobject.field_name,
IF(ISPICKVAL(API__c2, “Option2”), Sobject.field_name
IF(ISPICKVAL(API__c3, “Option3”), NULL))).

Thanks.

Log In to reply.