Skip to main content

Hello,

we would like to find a formula to count down 24 hours and end at 0 or if possible marked "canceled".

if anyone can help us i will be really grateful

thanks in advance

Try this:

IF(

ABS(

DATETIME_DIFF(

NOW(),

{Target Date},

'hours'

)

) != 24,

ABS(

DATETIME_DIFF(

NOW(),

{Target Date},

'hours'

)

),

"Cancelled"

)

 

Reply


Terms & Conditions