Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula for showing days remaining for a task?

Topic Labels: Formulas
Solved
Jump to Solution
2295 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!