Embed countdown in Smartsheet
I would like to embed a countdown for Go-Live into my project dashboard. Any idea?
Answers
-
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.
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
Paul,
Potentially the Web Widget could be used for that, but the domain has to be approved.
Look here for a list of approved domains: https://help.smartsheet.com/articles/2477606-web-content-widget
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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?
-
Hi Mitchell,
Maybe it could work with an approved domain that has a possibility for embedding.
Approved domains: https://help.smartsheet.com/articles/2477606-web-content-widget
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Is there a way to convert the countdown to months and not days?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives