I would like to embed a countdown for Go-Live into my project dashboard. Any idea?
On a blank SmartSheet use three cells. In the first cell use formula:
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.
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!
Workflow Consultant @ Get Done Consulting
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
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.
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
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?
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!
Workflow Consultant / CEO @ WORK BOLD