Skip to main content

Create an event countdown with a Number widget using a Google Sheet

Learn how to build a widget displaying a countdown number.

Updated over 2 weeks ago

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 might be counting down the days to the end of your current sprint, Christmas, or another due date.

Number_widget_result.png
  1. Make your own copy of this Google Sheets template.

  2. Double click the 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. Switch to Geckoboard account and add a new Spreadsheets widget.

  5. Connect your copy of the template sheet.

  6. Select the value of Days left until event, then choose a number visualization.

  7. Make any other changes and save your widget when ready.

Did this answer your question?