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.
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 columnB
. This returns a red circle π΄ for aTRUE
result, and a blue circle π΅ for aFALSE
result. We also created a column of concatenated cells in columnD
.Make a copy of this Google Sheet.
If preferred, make changes to the sheet to customize it for your needs.
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 columnB
. This returns a red circle π΄ for aTRUE
result, and a blue circle π΅ for aFALSE
result. We also created a column of concatenated cells in columnD
.
In Geckoboard, add a new widget to your dashboard and select the Spreedsheets data source.
Connect your Google Drive account if needed, search for the sheet you made a copy of, and select it from the list.
With your spreadsheet connected, select the range you want to display, e.g., the
A
andD
columns:Click Continue.
In the Visualization dropdown, select Table.
Make any other changes needed to your widget configuration, then click Save.