Using emojis with conditional formulas
  • 08 Dec 2023
  • 1 Minute to read
  • Dark
    Light
  • PDF

Using emojis with conditional formulas

  • Dark
    Light
  • PDF

Article summary

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

Plan availability

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🏃"))

1500018264941emojiTaskFormula51721.jpg

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

1500017968462emojiSimpleFormula51721.jpg


Was this article helpful?