Help

countdown in hours

Topic Labels: Formulas
523 1
cancel
Showing results for 
Search instead for 
Did you mean: 
TyronTi
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1

Try this:

Screenshot 2024-02-29 at 10.08.34 AM.png

IF(
  ABS(
    DATETIME_DIFF(
      NOW(),
      {Target Date},
      'hours'
    ) 
  ) != 24,
  ABS(
    DATETIME_DIFF(
      NOW(),
      {Target Date},
      'hours'
    ) 
  ),
  "Cancelled"
)