How to highlight table cells in Spreadsheets using Emoji

Though our table widget won't reflect any color-based conditional formatting from your spreadsheet, you can use Emoji to highlight particular cells. In this walkthrough, we'll show you how to use our Spreadsheets data source to display a table with conditional color-based Emoji on your dashboard.Widget displaying conditional Emoji indicators

  1. To begin, load our example Google sheet of sales per agent. To create our Emoji color indicators, we've used an IF function in the cells in column C to run a test of the preceding cell in column B. This returns a red circle 🔴 for a TRUE result, and a blue circle 🔵 for a FALSE result. We also have create a column of concatenated cells in column D.Example spreadsheet of sales per agent with conditional formatting
  2. Make your own copy of the spreadsheet using File > 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, click drag to select the cells in columns A. Then click the + button to the right of the data range field. Then click drag to select the concatenated cells in column DSelect cells from columns A and D from the spreadsheet
  7. Click > Confirm selection. From the the visualization options, click on the highlighted Table icon.
  8. On the next screen you'll see a preview of your example color coded widget. Click Add to dashboard to return to your dashboard.

You can also use Emoji with our text widget to help convey extra meaning and emotion on your dashboard.

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.