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 

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?

Thanks!

Shannon

goabhigogoabhigo

Easy,

 

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?