Using emojis with conditional formulas

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

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⏰",""))