I want to create a checkbox that shows me if the Currency on an Opportunity is DIFFERENT than the Currency on a Custom Object.
Currency field on the Opportunity is a Picklist though - what is the easiest way to get this to flag?
7 réponses
Which object are you creating the Formula(Checkbox) field on? You need to be able to access BOTH of the Picklist fields in order to build your Formula. Regardless, your basic Formula would be pretty simple
TEXT( PicklistField ) <> TEXT( Object__r.PicklistField )