+ Start a Discussion
anil.ax822anil.ax822 

formula fields that accepts picklist selected values

Hi;

i have 2 picklist say a,b

in a i have 1-10 values

in b if i have 4 then in formula field it should display Yes otherwise No

the same thing i achieved but it is hard coded

see like

 

IF(AND(ISPICKVAL(Pick1__c, "4"), ISPICKVAL(pick2__c, "4")),"yes", "no");

is it possible like dynamically passing values to formula fields

plz help

goabhigogoabhigo

Anil,

 

I did not understand when it should be 'Yes' and when 'No'. Is it when both picklist values are same then 'Yes' otherwise 'No'? Or only when the value is 4?