I am working around salesforce's formula field in Process Builder, to compare two fields values. For instance, the field Contact_A__c and Contact_B__c are picklist field types. I am attempting to compare several values of the picklist fields. In particular, I am attempting to create a comparison formula field to update the value of a text field "Result of Comparison" as an immediate action when the following condition is fulfilled.
IF(OR(ISPICKVAL([Comparison__c].Contact_A__c.Tipo__c, "Gold Partner",
CONTAINS([Comparison__c].Contact_B__c.Tipo__c, "Silver Partner")),
"The Contact A represent an excelent Opportunity")
However, it is appearing the following
Error message: "The formula expression is invalid: Field Comparison is a picklist field. Picklist fields are only supported in certain functions"
After to review http://resources.docs.salesforce.com/208/20/en-us/sfdc/pdf/salesforce_useful_formula_fields.pdf I understood better how to compare two text fields. But, I have not been able to identify what is required to overcome the error message. So, could you please suggest me how could be solved the error message of the formula field of Process Builder?
Best regards,