I created a custom field that shows me for how long the status of a lead has been on "open". Now I want to be informed by mail as soon as a lead (or even better: a group of leads) exceeds a specified time span the lead has been on "open".
Does anybody of you have any idea how this can be done?
Thanks in advance for your support.
How do I capture the duration of the status for reporting purposes?
A lead has open, working, closed status. It's opened on Sept 1st for 10 days switchs to working for 8, than closed till now. How do I track and record the duration of each status?
Is this achievable in Salesforce, if so do i need a formula?