function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jamie GelepJamie 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 DesaiShivani 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".