Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Feb 05, 2019 06:42 PM
Hey everyone,
I’m trying to figure out how to do this formula.
I have 3 columns with various dates (day startup is first contacted, day first meeting is set, day second meeting is set). Clearly these dates are going to be in progressive order.
There’s also another field called “investment declined.”
I’m trying to create a formula that calculates the # of days it took for a startup to either be fully analyzed and declined for investment, or the # of days the startup is currently in the funnel (pulling from the latest date among the 3 columns).
Can anyone help me out here? If you’re a Redditor I’ll give you Reddit gold hahaha.
Feb 06, 2019 03:23 AM
You have the function DATETIME_DIFF
that is just for that. The Investment Declined should be a date field. I would use nested IFs to check which is the last date registered:
IF(
{Investment Declined},
DATETIME_DIFF(
{Contacted Date},
{Investment Declined},
'days'
),
DATETIME_DIFF(
IF(
{Second Meeting},
{Second Meeting}
IF(
{Fist Meeting},
{Fist Meeting},
{Contacted Date}
)
),
TODAY(),
'days'
)
)