You need to sign in to do that
Don't have an account?
Laura 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
)
)
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
)
)
Do you see any error when it doesn't work?Thanks