Solved

DATETIME_DIFF if second date is blank

Hey everyone. I’m using this formula to calculate how many days it took for a response.

DATETIME_DIFF({Response date},({Submission date}), ‘days’) & " days"

I’d like to add a part to the logic that says if {Response date} is blank, calculate days between Submission date and today’s date.

Any ideas?

Best answer by kuovonne

For formulas like this, I like to use a multi-line format

DATETIME_DIFF(
  IF({Response date}, {Response date}, TODAY()),
  {Submission date}, 
  'days'
) 
& " days"

+29

For formulas like this, I like to use a multi-line format

DATETIME_DIFF(
  IF({Response date}, {Response date}, TODAY()),
  {Submission date}, 
  'days'
) 
& " days"

Sign up