Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 27, 2023 12:57 AM
I have this working formula to return 'Reaction Hours'...
Solved! Go to Solution.
Jun 27, 2023 03:04 AM
Hm, could you try removing the `,""` at the end there? So just:
IF(
AND({Reacted Date & Time},{Request Date & Time}),
ROUND(
DATETIME_DIFF(
{Reacted Date & Time},
{Request Date & Time},
'minutes'
)
/ 60,
2
)
)
I think that should show you the 0 like you want
Jun 27, 2023 03:04 AM
Hm, could you try removing the `,""` at the end there? So just:
IF(
AND({Reacted Date & Time},{Request Date & Time}),
ROUND(
DATETIME_DIFF(
{Reacted Date & Time},
{Request Date & Time},
'minutes'
)
/ 60,
2
)
)
I think that should show you the 0 like you want
Jun 27, 2023 03:13 AM
that worked great thanks! I thought I had to specify an else condition in these if statements but I guess not. No idea why the else condition was triggered though since both the values of the AND statement were present. Either way you fixed the bug so thanks again!