Formatting your spreadsheets

When you connect your spreadsheet, Geckoboard will automatically determine the data types in your cells. But to get the best results, it’s always worthwhile taking a few moments to review the format of your spreadsheet.

Preventing errors in your spreadsheet formulas

The IFERROR function enables you to protect against errors in your Google Sheets and Excel spreadsheet formulas.

In the event of your formulas returning common errors such as #NAME?, #VALUE!, #DIV/0!, and #REF!, IFERROR will provide a fallback and return a value you specify.

Tip

We recommend either leaving the cells empty, or, for numerical values, leaving a 0.

Syntax: IFERROR(value, value_if_error)

Further reading

Preventing errors due to locale date/time formats

Warning

If your spreadsheets contain cells with date/time values, Geckoboard should automatically recognize them. However, there could be some locale date formats which Geckoboard may not identify, which can cause trouble when building your widgets. For example: Germany's date format dd.mm.yyyy is not supported.

To make sure your dates/time values are formatted accordingly, please follow the steps below for Google Sheets:

  1. Select the entire row or column which the values are located.
  2. Go to Format
  3. Select Number
  4. Select More Formats
  5. Choose a data format from the list of options. We recommend choosing: MM/DD/YYYY OR DD/MM/YYYY.

Get in touch

If you are still having trouble formatting your spreadsheet drop us a line and we'll be happy to help!

Suggested next steps

Connect your spreadsheet with Geckoboard

Create a visualization from your spreadsheet

Was this article helpful?

Awesome! 👍  Thanks so much for your feedback!