- 08 Dec 2023
- 1 Minuto para leer
- Impresión
- OscuroLigero
- PDF
Using emojis with conditional formulas
- Actualizado en 08 Dec 2023
- 1 Minuto para leer
- Impresión
- OscuroLigero
- PDF
This article covers how to incorporate emojis into text strings using the IF statements in formula fields to streamline your team's and organization's work.
Introduction
All plan types | |
Platform(s) | Web/Browser, Mac app, and Windows app |
Related reading |
Applying emojis using IF statements in Airtable
NOTE
To access the emoji keyboard on a Mac, press Ctrl + CMD + Space.
To access the emoji keyboard on a Windows-based computer, press the Windows logo key + . (period key).
Here's an example of how to set up a conditional emoji formula. Suppose you wanted to have a Status field that would automatically mark overdue tasks in a way that makes them obvious. You have a Due Date column with dates, and a checkbox column called Completed.
There are three possible outcomes you would want to mark:
If the Completed box is checked, the Status field will say ✅Done✅
If the Completed box isn't checked, and the Due Date is before today, the Status field will say ⏰OVERDUE⏰
If the Completed box isn't checked, and the Due Date is today or after today, the Status field will say 🏃In-progress🏃
Translating this into a formula, we would get:
IF({Completed?} = 1, "✅Done✅",IF(IS_BEFORE({Due Date}, TODAY()), "⏰OVERDUE⏰","🏃In-progress🏃"))
To make the overdue records stand out more, you could also make the ✅Done✅ and 🏃In-progress🏃 records blank by using double quotation marks with nothing inside:
IF({Completed?} = 1, "",IF(IS_BEFORE({Due Date}, TODAY()), "⏰OVERDUE⏰",""))