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
Shannon.ax1730Shannon.ax1730 

Workflow Formula to exclude email domains

I have a workflow formula that sends an email survey:

 

AND(NOT(ISBLANK(Contact.Email)),OR( today() - DATEVALUE(Contact.Last_Survey_Sent_Date__c) >= 90,isBlank(Contact.Last_Survey_Sent_Date__c)&& IsClosed))

 

I need to figure out how to exclude email addresses from 2 email domains (e.g. @ABC.com and @123.com) in the workflow criteria.

 

Any help would be appreciated!

 

Shannon

 

 

Satish_SFDCSatish_SFDC

Use the CONTAINS() function.

 

AND(
	NOT(ISBLANK(Contact.Email)),
	NOT(CONTAINS(Contact.Email,"@ABC.COM")),
	NOT(CONTAINS(Contact.Email,"@123.COM")),
	OR( 
	    today() - DATEVALUE(Contact.Last_Survey_Sent_Date__c) >= 90,
	    isBlank(Contact.Last_Survey_Sent_Date__c)&& IsClosed
	)
)

 

Hope this helps!
Regards,
Satish Kumar
Please mark my answer as a solution if it was helpful so it is available to others as a proper solution.
If you felt I went above and beyond, please give me Kudos by clicking on the star icon.