Countdown to dates

Platform discussions Special workflows & use cases
1

We have timelines or dates, but want to see a countdown to that date. If there was a link column to a date or timeline start simply as a number to show how many days or weeks etc to that date. Awesome.

We have to use a separate iOs app to put project start dates in and see how many days or weeks we have to get our back-sides into gear!

1 Like
2

@DavidJames

This is something you could definitely achieve by using Formulas, or the General Caster app. Here’s how the Formula column solution would work:

image

Here is the Formula I used:
ROUND(DAYS({TImeilne#End},TODAY()),0)

If you need to display working days, you could also do that with the Workdays function:

image
image1090Ă—294 16.1 KB

Here is the formula too:
ROUND(WORKDAYS({TImeilne#End},TODAY()),0)

I’m going to move this into a different section of our community, as it seems like it’d be a better fit to generate discussion and helpful ideas there :slight_smile:

-Alex

1 Like
3

Mmmmmm…… Formulas, means me spending over £40 a month on Pro and it’s only little me as you have no 1 user option!..… I think I’ll stick to spreadsheets :wink:

4

On the formula provided is there a way to have the countdown show negative numbers if the date has come and gone?

Thanks!

6

These are great formulas. Is there a way to have negative values for overdue items?

7

I used this formula for a set data column (not a timeline column) and it shows negative numbers for past dates. My date column is called “Deadline”

IF(DAYS({Deadline#End}, TODAY()) >= 0,
ROUND(DAYS({Deadline#End}, TODAY()), 0),
-ROUND(DAYS(TODAY(), {Deadline#End}), 0))

8

made this today :slight_smile:

concatenate(
((roundup(days({Countdown},today()),0))-1),
"D ",
(roundup((24*(1-((roundup(days({Countdown},today()),0))-(days({Countdown},today()))))),0))-1,
"H ",
(roundup((60*(1-(roundup((24*(1-((roundup(days({Countdown},today()),0))-(days({Countdown},today()))))),0)-(24*(1-((roundup(days({Countdown},today()),0))-(days({Countdown},today())))))))),0)-1),
"m ",
(roundup(((60*(1-((roundup((60*(1-(roundup((24*(1-((roundup(days({Countdown},today()),0))-(days({Countdown},today()))))),0)-(24*(1-((roundup(days({Countdown},today()),0))-(days({Countdown},today())))))))),0))-((60*(1-(roundup((24*(1-((roundup(days({Countdown},today()),0))-(days({Countdown},today()))))),0)-(24*(1-((roundup(days({Countdown},today()),0))-(days({Countdown},today()))))))))))))),0)),
“s”)

image