Forum Discussion

RebekahAlcantar's avatar
RebekahAlcantar
Qrew Trainee
8 years ago

I am tracking aging of support tickets from two different systems.

I need help to create a formula to calculate a complex duration issue. I am tracking aging of support tickets from two different systems. Therefore, I have a total of 4 time stamps. ...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
I let Eric do the heavy lifting here.  But you can make the formula more readable like this


IF(
isnull([date 3]), [date 2]-[date 1],

not(isnull([date 3])) and isnull([date 4]),today()-[date 1],

not(isnull([date 3])) and not(isnull([date 4])),[date 4]-[date 1],
null)