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?

Page 1 / 1

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