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.
- Make your own copy of this Google Sheets template.
- Double click cell
B3and choose the date for your event i.e. Christmas day.
B5will automatically calculate how many days are left between now and that event.
- Switch to Geckoboard account and add a new Google Sheets widget.
- Connect your copy of the template sheet.
- Select the value of Days left until event, then choose a number visualization.
- Configure other widget options, such as giving it a Title. Click when you're ready.