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
Laura McCoy 4Laura McCoy 4 

Send email 20 business days after Submitted Date

Hello, 

We have a custom object called Submittals that has a field called Submitted Date. We would like to send an email to the Submittal Recipient from the Project Manager 20 Business days (business days are Monday-Friday) after that date. I have created a formula in Process Builder with criteria and an action w/an email alert but it doesn't seem to be working. 
Any ideas?  Thank you.

IF(MOD( [Submittal__c].Submitted_Date__c   - DATE(1900, 1, 6), 7) > 2,
[Submittal__c].Submitted_Date__c + 27,
IF(MOD( [Submittal__c].Submitted_Date__c  - DATE(1900, 1, 6), 7) > 0,
[Submittal__c].Submitted_Date__c + 25, [Submittal__c].Submitted_Date__c + 26
)
)
Laura McCoy 4Laura McCoy 4
User-added image
SwethaSwetha (Salesforce Developers) 
HI Laura,
Do you see any error when it doesn't work?Thanks
Laura McCoy 4Laura McCoy 4
No error message. I also posted this question on another page and was told the problem was that my formula is not criteria so should not be here. I should create a formula field on the object with this formula and then use it in the scheduled action section of the process. Then it should work. I will try that.