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?
help, I want to create a new custom field LEAD AGE on Lead Page, any idea about formula I have to use to know how many days each lead has since creating.thanks
