Troubleshooting the Spreadsheets integration

Why do my X-Axis dates not display correctly in my chart?

The most common issue is that the X-Axis dates are being calculated by a formula e.g. =today() or coming from another sheet =Sales!A1. Unfortunately our Spreadsheets integration cannot display these dates due to a limitation of the Google Sheets API; when the data comes through the API into our Spreadsheets integration, the information that it is a date is lost.

The easiest solution is to create another column with manually entered dates that Geckoboard will use to populate your charts.

The GIF below shows that the dates in Column A are coming from another Google Sheet. Our Spreadsheets integration is not able to display these dates in the X-Axis of the chart.FAQ_X-axis_dates_don%27t_display

To fix this, copy the dates from Column A and then go to Edit > Paste Special > Paste Values Only to paste them into another column. To format these as dates, go to Format > Number > Date. Alternatively, you can manually enter the dates.

In Geckoboard, set your Spreadsheets widget to use this new column of dates as the X-Axis of your chart (as shown in the GIF below).FAQ_X-Axis_dates_display_answer

How often will the data in my Spreadsheets widgets refresh?

Your Spreadsheets widget will automatically refresh every 15 minutes.

If you make changes to your sheet/worksheet in between those refreshes, the latest changes will not immediately be reflected; however, the changes will be picked up in the subsequent widget refresh.

Can I force the data in my Spreadsheets widgets to refresh?

You can indeed force the values to update by editing the widget and using the 'Reload spreadsheet' feature. Remeber to Save once you're done!

On the edit widget screen's breadcrumbs menu, click the downward arrow beside the name of your widget.Edit widget breadcrumbs

Why is my deleted spreadsheet on Google Drive still powering my widget?

When you delete a spreadsheet from your Google Drive account, it will automatically be placed inside your Trash folder. Items in your Trash folder are still, in effect, regarded as active documents until emptied. To ensure your spreadsheet will no longer power your widget, go to your Trash folder and manually delete the spreadsheet.

Get help

If you're still having trouble with errors on your Spreadsheets, get in touch.

Why am I seeing a "Cannot read property 'offsetWidth' of undefined" error?

This error will occur if you only have one row of data to select from. Check if you have selected the Use first selection cell as header option. Keep in mind that values must be consecutive to use them within a widget.use first selection cell as header

Was this article helpful?

Awesome! 👍  Thanks so much for your feedback!