Countdown to Launch Days

John Littler

If today is Jan. 28th and I have a launch date of a project of say Oct. 1st, what formula would I use to countdown the days to Oct. 1 for a dashboard widget? So 246 days, then 245 tomorrow and so on.

Paul Newcome

Try something along the lines of...

=DATE(2021, 10, 01) - TODAY()

Paul Newcome

Try something along the lines of...

=DATE(2021, 10, 01) - TODAY()

John Littler

Beauty, worked like a charm...thanks for the help!

Paul Newcome

Happy to help.️

Brandon Pinsky

@John Littleris this formula actually updating the widget on your dashboard each day? I read in another post that when using this for a dashboard, it doesn't actually update unless someone opens the source data sheet. Thanks.

John Littler

@Brandon Pinskyyou are correct, my source data sheet needs to be open or dashboard refreshed to update.

Andrée Starå

Hi@Brandon Pinsky&@John Littler

Please have a look at my post below with a method I developed to update the sheet(s) daily (without opening them).

More info:

Hi everyone,<\/p>

Happy New Year!<\/p>

I hope you're well and safe!<\/p>

I've developed a way to use the newly released Record a date <\/strong>feature to update sheets with today's date automatically without the need to open it or similar.<\/p>

1.<\/strong><\/p>

Add a so-called helper column. (Date)<\/p>

We can call it Today Helper and add a date before the current day.<\/p>

2.<\/strong><\/p>

You'd then use an Automation Workflow as described below.<\/p>

Trigger:<\/strong> When a date is reached<\/p>

Every day starting on 2021-01-06 (today or earlier)<\/em><\/p>

02:00 (select the time that makes the most sense for the process)<\/em><\/p>

Conditions<\/strong><\/p>

Where Today Helper<\/strong> is in the past<\/p>

Record a date<\/strong><\/p>

Record a date in Today Helper<\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/1R2CO9WEE5M5\/screenshot-of-ghost-browser-282021-01-06-2c-14-22-21-29.jpg<\/a><\/p>

This could also be structured so you'd use a so-called helper sheet for the process above and then link it to all other sheets where you'd need the daily update.<\/em><\/p>

Let me know if you have any questions!<\/p>

I hope that helps!<\/p>

Stay safe, and Happy New Year!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by <\/em>marking it as helpful<\/em><\/strong>. It will make it easier for others to find a solution.<\/em><\/p>","bodyRaw":"[{\"insert\":\"Hi everyone,\\n\\nHappy New Year!\\nI hope you're well and safe!\\n\\nI've developed a way to use the newly released \"},{\"attributes\":{\"bold\":true},\"insert\":\"Record a date \"},{\"insert\":\"feature to update sheets with today's date automatically without the need to open it or similar.\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"1.\"},{\"insert\":\"\\nAdd a so-called helper column. (Date)\\nWe can call it Today Helper and add a date before the current day.\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"2.\"},{\"insert\":\"\\nYou'd then use an Automation Workflow as described below.\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Trigger:\"},{\"insert\":\" When a date is reached\\nEvery day starting on 2021-01-06 \"},{\"attributes\":{\"italic\":true},\"insert\":\"(today or earlier)\"},{\"insert\":\"\\n02:00 \"},{\"attributes\":{\"italic\":true},\"insert\":\"(select the time that makes the most sense for the process)\"},{\"insert\":\"\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Conditions\"},{\"insert\":\"\\nWhere\"},{\"attributes\":{\"bold\":true},\"insert\":\" Today Helper\"},{\"insert\":\" is in the past\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Record a date\"},{\"insert\":\"\\nRecord a date in Today Helper\\n\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/1R2CO9WEE5M5\\\/screenshot-of-ghost-browser-282021-01-06-2c-14-22-21-29.jpg\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/1R2CO9WEE5M5\\\/screenshot-of-ghost-browser-282021-01-06-2c-14-22-21-29.jpg\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\\n\\n\"},{\"attributes\":{\"italic\":true},\"insert\":\"This could also be structured so you'd use a so-called helper sheet for the process above and then link it to all other sheets where you'd need the daily update.\"},{\"insert\":\"\\n\\nLet me know if you have any questions!\\n I hope that helps!\\nStay safe, and Happy New Year!\\nBest,\\n\"},{\"attributes\":{\"bold\":true,\"link\":\"mailto:andree@workbold.com\"},\"insert\":\"Andrée Starå\"},{\"insert\":\" | Workflow Consultant \\\/ CEO @ \"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/workbold.com\\\/\"},\"insert\":\"WORK BOLD\"},{\"insert\":\"\\n✅\"},{\"attributes\":{\"italic\":true},\"insert\":\"Did my post(s) help or answer your question or solve your problem? Please help the Community by \"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"marking it as helpful\"},{\"attributes\":{\"italic\":true},\"insert\":\". It will make it easier for others to find a solution.\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2021-01-06T13:40:12+00:00","insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/74527\/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar","embedType":"quote","name":"Daily Update Solution without the need to open the sheet, use Zapier, or similar"}"> https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

Would that help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@Andrée StaråI use a similar setup with 24 rows so that it updates every hour. I only have a few different use cases for it, but at least it is available in addition to daily.