function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Help with Workflow formula

I have a formula that sends an email if it meets this criteria:

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

I need to add that the case needs to be closed as well. 

Can someone assist?






AND( ISPICKVAL( Status, 'Closed'),

 OR ( Today() - DATEVALUE(Contact.Last_Survey_Sent_Date__c) >= 90, ISBLANK(Contact.Last_Survey_Sent_Date__c))



Is that what you are looking for?


I am not sure why you have ISBLANK(Contact.Last_Survey_Sent_Date__c)?? What are you trying to check apart from checking previous sent date was 90 days ago?