Embed countdown in Smartsheet

B@Tz · 06/19/19

I would like to embed a countdown for Go-Live into my project dashboard. Any idea?

Lachlan Stead · 06/20/19

On a blank SmartSheet use three cells. In the first cell use formula:

=TODAY())

In second cell enter GoLive date

In third cell use formula:

='Cell2' - 'Cell1'

(E.g. =[Column3]1 - [Column2]1)

Then, on your dashboard, follow the below process in the image...

and there you have it, a count down to the GoLive date.

Andrée Starå · 06/20/19

Hi,

To add to Lachlan's suggestion. The sheet with the counter has to be "Activated" for the counter to update.

Activated= Something needs to change and be saved on the sheet.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome · 06/20/19

I wonder too if there is a way to use the URL widget to display an actual countdown timer from another app or website...?

This would help avoid the drawbacks of the TODAY() function.

Andrée Starå · 06/20/19

Paul,

Potentially the Web Widget could be used for that, but the domain has to be approved.

mitchell.beness113091 · 12/03/19

I found this countdown timer which is what I want but its not approved.

Does anyone know how to make something using an approved domain?

Andrée Starå · 12/03/19

Hi Mitchell,

Maybe it could work with an approved domain that has a possibility for embedding.

I think that it maybe could work with Google Slides, MS PowerPoint, Prezi, or similar.

Would that work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

bfitzsimmons · 03/27/24

Is there a way to convert the countdown to months and not days?

Smartsheet Basics