Skip to main content
Solved

Formula for showing days remaining for a task?

  • May 14, 2021
  • 2 replies
  • 79 views
T
Forum|alt.badge.img+7

Hi, what formula can I use to show many days remain for a task?

For example, if there are 4 days remaining before the Due Date, I’d like that cell to read “4”

I tried using a formula from another table but it didn’t work. The existing formula was: IF({Name (from Due Date)}, DATETIME_DIFF({Name (from Due Date)}, TODAY(), ‘days’))

My new formula is: IF({Follow Up Date}), DATETIME_DIFF({Follow Up Date}), TODAY(), ‘days’)) - but this one doesn’t seem to function correctly.

Any help is greatly appreciated. Thanks! Christopher

Best answer by JonathanBowen

Hi @Torus_Global - you’re nearly there. There’s a couple of stray RH brackets that must have got copied over. Try this

IF({Follow Up Date}, DATETIME_DIFF({Follow Up Date}, TODAY(), 'days'))

2 replies

JonathanBowen
Forum|alt.badge.img+18
  • JonathanBowen
  • Inspiring
  • Answer
  • May 15, 2021

Hi @Torus_Global - you’re nearly there. There’s a couple of stray RH brackets that must have got copied over. Try this

IF({Follow Up Date}, DATETIME_DIFF({Follow Up Date}, TODAY(), 'days'))
T
T
Forum|alt.badge.img+7
  • Torus_Global
  • Author
  • Known Participant
  • May 17, 2021

Hi @Torus_Global - you’re nearly there. There’s a couple of stray RH brackets that must have got copied over. Try this

IF({Follow Up Date}, DATETIME_DIFF({Follow Up Date}, TODAY(), 'days'))

Bingo, that was it. Thanks, @JonathanBowen!

Terms & ConditionsAccessibility statement