Geckoboard

In this guide we'll show you how to use our Spreadsheets data source to display a table widget with conditional color-based Emoji on your dashboard.

Widget displaying conditional Emoji indicators

To begin, <a href="https://docs.google.com/spreadsheets/d/11Fd4DrhiM1oZIpkF1nobiLpYq6M3IJ1aSdYRZng1WS4/edit?usp=sharing" rel="nofollow noopener noreferrer" target="_blank">load our example Google sheet of sales per agent</a>.

To create our Emoji color indicators, we used an IF function in the cells in column <code>C</code> to run a test of the preceding cell in column <code>B</code>. This returns a red circle 🔴 for a <code>TRUE</code> result, and a blue circle 🔵 for a <code>FALSE</code> result. We also created a column of concatenated cells in column <code>D</code>.

Example spreadsheet of sales per agent with conditional formatting

Make your own copy of the spreadsheet using File &gt; Make a copy.

Switch to Geckoboard. Click Add widget in the top right of your dashboard.

You'll see a scrollable list of data sources. Click Google Sheets.

From the Choose File menu, search for, and select, the spreadsheet you want to connect to Geckoboard.

Choose your Google Sheet from your Google Drive

With your spreadsheet connected, you can select your data. Select the <code>A</code> and the <code>D</code> columns.

Select cells from columns A and D from the spreadsheet

Click Continue. In the Visualization dropdown, select Table.

You'll see a preview of your example color-coded widget. Click Save to return to your dashboard.

1. To begin, <a href="https://docs.google.com/spreadsheets/d/11Fd4DrhiM1oZIpkF1nobiLpYq6M3IJ1aSdYRZng1WS4/edit?usp=sharing" rel="nofollow noopener noreferrer" target="_blank">load our example Google sheet of sales per agent</a>. 
 
 To create our Emoji color indicators, we used an IF function in the cells in column <code>C</code> to run a test of the preceding cell in column <code>B</code>. This returns a red circle 🔴 for a <code>TRUE</code> result, and a blue circle 🔵 for a <code>FALSE</code> result. We also created a column of concatenated cells in column <code>D</code>.
 
 Example spreadsheet of sales per agent with conditional formatting
2. Make your own copy of the spreadsheet using File &gt; Make a copy.
3. Switch to Geckoboard. Click Add widget in the top right of your dashboard.
4. You'll see a scrollable list of data sources. Click Google Sheets.
5. From the Choose File menu, search for, and select, the spreadsheet you want to connect to Geckoboard.
 Choose your Google Sheet from your Google Drive
6. With your spreadsheet connected, you can select your data. Select the <code>A</code> and the <code>D</code> columns.
 Select cells from columns A and D from the spreadsheet
7. Click Continue. In the Visualization dropdown, select Table.
8. You'll see a preview of your example color-coded widget. Click Save to return to your dashboard.

You can also add emojis to your <a href="https://support.geckoboard.com/en/articles/6055783-add-emoji-to-dashboard-widgets">widget titles and labels</a>, as well as in our <a href="https://support.geckoboard.com/en/articles/6055637-use-the-text-widget-to-display-text-on-your-dashboard">Text widget</a>, to help convey extra meaning and emotion on your dashboard.