Hi. I’m looking to track how much time (in days) a lead spends in each stage in a pipeline. I’m basing it on start and stop dates of time in stage. The formula I’m trying to accomplish is this (hope it makes sense):
Is the start date blank?
YES: Do n...
Kamille_Parks:
IF(
{Start Date},
DATETIME_DIFF(
IF({End Date}, {End Date}, TODAY()),
{Start Date},
'days'
)
)
This works perfect. I’ll study and keep in mind for the future. Thank you!
