You need to sign in to do that
Don't have an account?
Victor Nguyen 13
Invoke another process when no Activity and no Stage update 4 days (weekend excluded) after created date
Hi everyone,
I'm having trouble setting up on process builder. I want it to invoke another process 4 days (weekend excluded) after created date when no Activity and no StageName updated.
Below is the formula that trigger the action
Where Opportunity_Age__c is a formula fields (return type is Number):
It doesn't work for some reasons. Please give me some advice on this.
I'm having trouble setting up on process builder. I want it to invoke another process 4 days (weekend excluded) after created date when no Activity and no StageName updated.
Below is the formula that trigger the action
MOD([Opportunity].Opportunity_Age__c , 1) = 0 && ISNULL([Opportunity].Last_Activity_Subject__c) && ISPICKVAL([Opportunity].StageName , 'New')
Where Opportunity_Age__c is a formula fields (return type is Number):
(5 * ( FLOOR( ( NOW() - DATETIMEVALUE("1900-01-08 00:00:00")) / 7 ) ) + MIN( 5, MOD( NOW() - DATETIMEVALUE("1900-01-08 00:00:00"), 7 ) ) ) - (5 * ( FLOOR( ( DATETIMEVALUE(CreatedDate) - DATETIMEVALUE("1900-01-08 00:00:00") ) / 7 ) ) + MIN( 5, MOD( DATETIMEVALUE(CreatedDate) - DATETIMEVALUE("1900-01-08 00:00:00"), 7 ) ) )
It doesn't work for some reasons. Please give me some advice on this.