I am trying to use this formula for a WorkFlow but Salesforce keeps giving me errors about two fields which are picklists. Anyone know what I am doing wrong?
This is the code and the error is below...
(GW_Volunteers__Start_Date__c >= TODAY() +2) && (ISPICKVAL(GW_Volunteers__Status__c, "Confirmed")) && ( ISPICKVAL( GW_Volunteers__Volunteer_Shift__r.GW_Volunteers__Volunteer_Job__c, "Recurring Shift Job" )) && (GW_Volunteers__Contact__r.Email <> "")
The error message:
Error: Incorrect parameter type for function 'ISPICKVAL()'. Expected Picklist, received Lookup(Volunteer Job)