+ Start a Discussion
Shannon.ax1730Shannon.ax1730 

Workflow to send a survey = today() - DATEVALUE(Last_Survey_Sent_Date__c) >= 90

I created a workflow formula to send a survey if Last Survey Sent Date is greater than or equal to 90 days. I need to also send the survey if there is no date in the field (as in the case of a new contact). 

 

Can anyone help me add to this formula?

 

Thanks in advance for your help!

 

today() - DATEVALUE(Last_Survey_Sent_Date__c) >= 90

Shannon.ax1730Shannon.ax1730
I also need it to trigger on case closed. Thanks.
Naveen NelavelliNaveen Nelavelli

check out this

OR( today() - DATEVALUE(Last_Survey_Sent_Date__c) >= 90,isBlank(Last_Survey_Sent_Date__c))