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.
