You need to sign in to do that
Don't have an account?
Jamie Gelep
Age of Lead
Hi All,
We would like to calculate the age of our lead but have it start over from zero each time the status changes. E.g. if a lead is "Open" for 3 days and then changed to "Contacted" and stays "Contacted" for 2 days, we would like to have "Open" = 0o and "Contacted" = 2. We have already created the fields for each of our statuses... just need help building the formula now.
Thanks!
Jamie
Shivani Desai
You might need one more formaula field that captures the date when status of a lead is changed. Then check in all the formula fields if the current status is what the field names states for eg if the current status is open then open's value would be today- status change date else it will be "00".