+ Start a Discussion
DevLauraDevLaura 

How do I write this email opt-out workflow formula?

I need to create a workflow on the Email field that will check Email Opt Out if the Email field was previously NOT blank, but has been changed to be blank.

I've tried the following and it doesn't work. Is anyone able to help with this? Thank you in advance:

AND( 
ISNULL(Email), 
NOT(ISNULL(PRIORVALUE(Email))))
 
Best Answer chosen by DevLaura
Maharajan CMaharajan C
Hi,

Please try the below formula's

ISBLANK(Email) && NOT(ISBLANK(PRIORVALUE(Email)))

Or You can also use the below formula; 

ISBLANK(Email__c) && NOT(ISBLANK(PRIORVALUE(Email__c)))&&ISCHANGED(Email)

Can you please let if it helps or you need any further help!!!

If it helps choose this as a best answer!!!

Thanks