I am using the following formula as the "Due date" for created tasks, but unfortunately it is not populating when the task is created in the flow. Any ideas?
DATE(YEAR({!$Record.Entered_Working_Status__c}), MONTH({!$Record.Entered_Working_Status__c}), DAY({!$Record.Entered_Working_Status__c})) + 7 - CASE(MOD(VALUE(TEXT(DATE(YEAR({!$Record.Entered_Working_Status__c}), MONTH({!$Record.Entered_Working_Status__c}), DAY({!$Record.Entered_Working_Status__c})))), 7), 0, 1, 1, 2, 2, 3, 3, 4, 4, 5, 5, 6, 6)
5 respostas
FYI. Using the following formula make the due date work as expected. ONly assiging it during business days.
DATE(YEAR({!$Record.Entered_Working_Status__c}), MONTH({!$Record.Entered_Working_Status__c}), DAY({!$Record.Entered_Working_Status__c})) + 7 + MOD(9 - WEEKDAY({!$Record.Entered_Working_Status__c}), 7)
