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" )