Conditional formulas with emoji
  • 16 Nov 2022
  • 1 Minute to read
  • Dark
    Light

Conditional formulas with emoji

  • Dark
    Light

Incorporating colorful emoji into conditional (IF) statements in a formula field is a great way to automatically flag records meeting certain conditions.

If you have Windows 10, you can bring up an emoji picker by typing windows . or windows ;.

If you have a Mac, you can bring up an emoji picker by typing cmd ctrl space.

Alternatively, you can also copy and paste your favorite emoji from Emojipedia.

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

Now, go forth and write some IF formulas! 👍💥🔥💣

For a more robust way to automatically color-code your records based on conditions, please see this article on record coloring, which is a premium feature for our customers on Pro plans.


Was this article helpful?