Using emojis with conditional formulas in Airtable

Updated
  • Updated on Oct 24, 2025
  • Published on Jul 5, 2022
  • 1 minute(s) read
Prev Next

Plan Availability

All plan types

Permissions

  • Owner / Creator - Can add, delete, duplicate, rename, and customize fields

  • Editors - Sort, filter, group, hide, and copy field URL

  • Commenters / Read-only - Copy field URL

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

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