+ Start a Discussion
bharath kumar 52bharath kumar 52 

picklist formulas not working in process builder

Hi,

I am trying to build a formula in process builder where i need to check if the country's picklist value is either "United States" or "US" or "United States of America" but the thing is only United States is in the picklist(which is ok). But when i try to use the below formula in process builder i get a error message as shown below . Can someone help me out ?
Formula result is data type (Boolean), incompatible with expected data type (Text)
//my code

ISPICKVAL([Deal_Registration__c].Country__c,"United States")||
ISPICKVAL([Deal_Registration__c].Country__c,"United States of America")||
ISPICKVAL([Deal_Registration__c].Country__c,"US")

User-added image
Maharajan CMaharajan C
HI Bharath,

Use the below formula:
 
IF( ISPICKVAL([Deal_Registration__c].Country__c , 'United States' ), 'United States',
IF( ISPICKVAL([Deal_Registration__c].Country__c , 'United States of America' ), 'United States of America',
IF( ISPICKVAL([Deal_Registration__c].Country__c , 'US' ), 'US',
NULL)))

And Use the Operator as Equals dont use contains. Refer the below screenshot:

User-added image

Thanks,
Maharajan.C