Create a countdown of days until an event

Countdowns can often complement other metrics you're tracking on a dashboard. For example, your metrics might focus on quarterly sales and so you want to show how many days remain in this quarter, or you're counting down the days to the end of your current sprint, Christmas, or another due date.

To set up your countdown timer, follow these steps:

  1. Make your own copy of this template.
  2. Double click cell B3 and choose the date for your event i.e. Christmas day.
  3. Cell B5 will automatically calculate how many days are left between now and that event.
  4. Now switch to your Geckoboard account, click Add widget and select Spreadsheets.
  5. If you haven't already, connect your Google Sheets account to Geckoboard.
  6. Select the Sheet created above (your own copy of the Template).
  7. Select the value of Days left until event, then choose a number visualization.
  8. Configure other widget options, such as giving it a Title.
  9. Click Add to dashboard to add your widget to your dashboard.
  10. And that's it! Your widget should look something like this: Number_widget_result.png
Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

We're ready to help, 24 hours a day, 5 days a week

Get support
  • Fernanda Customer Success Avatar

    Megan

    USA
  • Hariharan Customer Success Avatar

    Hariharan

    India
  • Fernanda Customer Success Avatar

    Yasmin

    Spain
  • Luis Customer Success Avatar

    Luis

    UK
  • Richard Customer Success Avatar

    Richard

    UK
  • Fernanda Customer Success Avatar

    Fernanda

    Brazil
  • Heather Customer Success Avatar

    Heather

    USA