Using emojis with conditional formulas in Airtable

Prev Next
Plan AvailabilityAll plan types
Required permissionsOwner / Creator - Can add, delete, duplicate, rename, and customize fields
Platform(s)Web/Browser, Mac app, and Windows app (with some additional limited support on mobile)

Applying emojis using IF statements in Airtable overview

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.

How do I access the emoji keyboard when in Airtable?

  • To access the emoji keyboard on a Mac: Press Ctrl + CMD + spacebar.

  • To access the emoji keyboard on a Windows-based computer: Press the Windows logo key + “. “ (period key).

How can I use emojis with conditional formulas in Airtable?

In this example, you want a "Status" field that automatically marks tasks when they are “Overdue”. You also have a "Due Date" column with dates and a checkbox column titled "Completed."

In this example, there are 3 possible outcomes:

  • If the “Completed” box is selected, the “Status” field reads “Done.”

  • If the “Completed”  box isn't selected, and the due date is before today’s date, the “Status” field reads“Overdue.”

  • If the Completed box isn't selected, and the due date is today or after today’s date, the “Status” reads “In-progress.”

What formula is used in this example?

IF({Completed?} = 1, "Done",IF(IS_BEFORE({Due Date}, TODAY()), "Overdue","In-progress"))