+ Start a Discussion
northcountrygalnorthcountrygal 

how do I make a workflow rule that will send email alert when any of 3 date fields are populated?

I need a workflow rule to send an email alert when any of 3 date fields are populated.

I tried the following but I am receiving a syntax error that I'm missing a bracket. 

IF(ISBLANK(Fieldone__c) , 
IF IF( ISBLANK( Fieldtwo__c ) ,
IF( ISBLANK( Fieldthree__c ) , false, true) ,  
true)
RKSalesforceRKSalesforce
Hello,

Please create condition like below: I have highlighted my filter logic with yellow color.
User-added image

Hope this will work.
Danish HodaDanish Hoda
IF(ISBLANK(Fieldone__c) , 
IF IF( ISBLANK( Fieldtwo__c ) ,
IF( ISBLANK( Fieldthree__c ) , false, true) ,  
true)
)