Conditional formulas with emoji

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 CtrlSpace.

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 which 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🏃