Conditional Workflow Rule
we have a requirement where we want to send an e-mail notification to the opportunity owner, when a certain status is not reached after the close date.
F.E. : Close date is 23/10 -> if status is not changed to 'XXXX' after 2 weeks, so on 06/11, an e-mail should be sent.
I have tried this using following setup:
Business Object : Opportunity
Event: Close Date
Relative Time: After
Time offset: 2 weeks
Custom status = 'Won' and custom field NE 'Created'
Custom status = 'Won' and custom field NE 'No Project Needed'
This setup results in the system checking the conditions on close date and executing the mail 2 weeks after.
It is not what we require.
The conditions should be checked 2 weeks after the close date, and then send the mail if the conditions are met.
Is there a way we can achieve this?
Thanks and kind regards,