Skip to main content

Highlight table widget cells in spreadsheets using emoji

Learn how to build a table widget with conditional color-based emoji using a spreadsheet.

Updated this week

In this guide, we'll cover how to use the Spreadsheets data source to display a table widget with conditional color-based emojis on your dashboard.

Widget displaying conditional Emoji indicators
  1. To create our Emoji color indicators, we 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 created a column of concatenated cells in column D.

    Example spreadsheet of sales per agent with conditional formatting
  2. Make a copy of this Google Sheet.

    1. If preferred, make changes to the sheet to customize it for your needs.

    2. For reference, to create the emoji color indicators, we 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 created a column of concatenated cells in column D.

  3. In Geckoboard, add a new widget to your dashboard and select the Spreedsheets data source.

  4. Connect your Google Drive account if needed, search for the sheet you made a copy of, and select it from the list.

  5. With your spreadsheet connected, select the range you want to display, e.g., the A and D columns:

    Select cells from columns A and D from the spreadsheet
  6. Click Continue.

  7. In the Visualization dropdown, select Table.

  8. Make any other changes needed to your widget configuration, then click Save.

    Widget displaying conditional Emoji indicators
Did this answer your question?