ShowAll Questionssorted byDate Posted
petyrc-

# Looking for formula that shows number of days until lead was converted

We're implementing some business rules that require a sales rep to convert a lead within a certain number of days.

Looking for a formula that will show me the number of days it took to convert the lead.

thanks,

p

rpr2

Here's a formula that will tell you the number of days it took to convert a lead:

ConvertedDate - Datevalue(CreatedDate)

There won't be any value though until after the lead get's converted.  Will that meet your need?

Jakester

Hmmm...

I can't find a way to do this exactly, but I have a workaround. You could make a report off of Leads, Leads with converted information, and include the created date and converted date, and only show leads that have been converted, then you could run this daily. You'd have to do the math yourself for how many days it took to convert. Conversely, you could run a daily report that shows non-converted leads that haven't been converted that are over a certain age.

JorgeSFDC

There are a few solutions in help and training that could help you out:

Type in: Formula - Weekend Days or Workdays Calculation

or

Type in: How to express the difference of 2 Date/Time fields in days,hours,mn format ?

Hope this helps,

J

Steve :-/

What about "flipping it around" and creating a workflow rule that notifies the owner (or their Boss) if the Lead hasn't been converted X days after it was created, or assigned...

Something like

NOT(IsConverted)

Workflow Rule:

Immediate Workflow Actions: NONE

Time Dependant Workflow Actions:  15 Days After Lead Created Date

Time Dependant Workflow Actions:  30 Days After Lead Created Date

Action: Email Lead Owner, and Team Exec

rpr2

Here's a formula that will tell you the number of days it took to convert a lead:

ConvertedDate - Datevalue(CreatedDate)

There won't be any value though until after the lead get's converted.  Will that meet your need?

This was selected as the best answer
petyrc-
s perfect! thanks rp2