You need to sign in to do that
Don't have an account?
Glenn Nyhan 54
Formula In Workflow Rule for a Field Update No Working
I have a picklist field called Membership Has Ended, there is only one value in the field which is 'Yes'. I have workflow formula (see below) I'm trying to use to update the field to Yes. But I can't seem to get it to work. Does anyone have any ideas. The syntax checks out as ok, but its still not updating the Membership Has Ended field. Anyone have an idea why this isn't working.
npe01__Membership_End_Date__c = TODAY() - 30 && ISPICKVAL(Payment_Channel__c, "Click and Pledge") && Last_Membership_Origin__c = 'Annual'
npe01__Membership_End_Date__c = TODAY() - 30 && ISPICKVAL(Payment_Channel__c, "Click and Pledge") && Last_Membership_Origin__c = 'Annual'
Check this below:
AND(npe01__Membership_End_Date__c = (TODAY() - 30) , ISPICKVAL(Payment_Channel__c, "Click and Pledge") , Last_Membership_Origin__c = 'Annual' )
Please mark this as best answer if you find it positive.
Thanks
Jolly Birdi