I would be greatful if you could help.
I have a custom formula field "Acceptability Rating" and i want it to look at two picklist fields "Status" and "Ruled out reason" and from the results in those fields determine the Acceptability rating as Acceptable, Unacceptable or Undetermined.
There are 10 different status and there are 20 ruled out reasons and dependent of which picklist item is selected will determine the rating. I have managed to do a formula that looks at a single field and picklist value (see below) is there a quick and easy way to do multiple values in this scenario ?
example Status picklist items - "New", "LNC", "Unqulified", "Dealt"
example Ruled out Reason picklist items - "Lost contact", "bought elsewhere"
current formula -
IF( ISPICKVAL( pba__Status__c , "New"), "Undetermined", "")