You need to sign in to do that
Don't have an account?
bharath kumar 52
How can i compare a picklist's values in a formula 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)
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)
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")
Use the below formula:
And Use the Operator as Equals dont use contains. Refer the below screenshot:
Thanks,
Maharajan.C
You can use the below formula to solve your query also use the Equal operator for comparision
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)))
I hope you find the above solution helpful. If it does, please mark it as Best Answer to help others too
Thanks and Regards,
Suraj Tripathi
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)))
it really works for me. Thanks mate.