I'm trying to create a custom case formula field so I can create a view that allows someone to view all cases where the case owner belongs to a certain site as defined on their user object in the picklist value "Work_Site__c":
I am receiving the following error:
Error: Field Work_Site__c is a picklist field. Picklist fields are only supported in certain functions.
Are picklists not accessible through formulas or are they not accesible through cross-object formulas?
Any recommended workarounds?