The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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!