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
Eric_J_Hansen's avatar
Eric_J_Hansen
Qrew Cadet
8 years ago
IF(
isnull([date 3]) and isnull([date 4),today()-[date 1],

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)