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

    Using emojis with conditional formulas

    • Dark
    • 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?