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

• How to use the IFERROR function in Google Sheets
• How to use the IFERROR function in Excel
  
  

Suggested next steps

Connect your spreadsheet with Geckoboard

Create a visualization from your spreadsheet