Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula for showing days remaining for a task?

Topic Labels: Formulas
Solved
Jump to Solution
2834 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Torus_Global
6 - Interface Innovator
6 - Interface Innovator

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

Screenshot 2021-05-14 at 20.47.47

1 Solution

Accepted Solutions
JonathanBowen
13 - Mars
13 - Mars

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

See Solution in Thread

2 Replies 2
JonathanBowen
13 - Mars
13 - Mars

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!