Help

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

Yet Another Date Formula Question!

Topic Labels: Formulas
702 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

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'
	)
)