Conditional logic in functions

Hello, we have a tracker setup with custom fields: Date1, Date2, and Lag. What we want is to have Lag be blank if Date2 has a value, otherwise it will be calculated as Today - Date1.

Any suggestions?

1 Like

Hi @Matt_Kolker, thank you for the question.
I did some experiments but couldn’t find an easy solution.

  • Formula custom fields: only subtraction is supported for date fields, so we can’t do something like multiplying by zero.
  • Rule: it’s possible to clear Date1 when Date2 is set, and the Lag field is cleared as well. I’m not sure if it suits your needs though.

Screen Recording 2024-03-18 at 23.54.35