function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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))