+ Start a Discussion

formula fields that accepts picklist selected values


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




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?