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
JMLJML 

Lead Age calculation not based on create date

My scenario is slightly different - and I'm wondering if you can help. I am trying to calculate the age of an "Open" lead. I found some in the sample formulas - If(ISPICKVAL(Status, "Open"), Round(NOW()-CreatedDate,0),Null) but - an "open date" could be after the create date. I thought perhaps using last modified would help- but that wouldn't do it. Is there a date field associated with Lead History? Thoughts?
Pal2011Pal2011

HI,


Are you able to find any solution? I've to do the same thing. I need to measure how many days Leads is in open/contacted status separately.

 

Any help would be greately appreciated.

 

Thanks,