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
)
)

Is there any way to relate a record's fields to each other within the record? 
For example, on a record we would like to create 5 fields to represent the upcoming years 2021, 2022, 2023, 2024, 2025.  Then we want to associate those years with other fields on the same record such as Price, Spend, Savings. By doing so, we will be able display the total spent for that year or how much saved, ect.
It is similar to a spreadsheet/table.  We also need to be able to REPORT on the fields.
Any ideas or guidance would be greatly appreciated!

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
)
)