Forum Discussion

RebekahAlcantar's avatar
RebekahAlcantar
Qrew Trainee
7 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
Eric_J_Hansen's avatar
Eric_J_Hansen
Qrew Cadet
7 years ago
if(isnull([date 3]), [date 2]-[date 1],
if(not(isnull([date 3])) and isnull([date 4]),today()-[date 1],
if(not(isnull([date 3])) and not(isnull([date 4])),[date 4]-[date 1],
null)))