Date-Based IF Statement

Hi!

I have a project management base with a series of dates for different stages of the production process. I want to have a series of corresponding “Function” fields that would flip to “Past Due” when a deadline passes. I am very new to Airtable and have had difficulty with writing date-based formulas.

Thanks in advance!

Hey @Shayan_Saalabi, welcome to the community!

You can use a formula like the one below for this. Note that I used Deadline as the field name (you’ll see it referenced within curly brackets) so you’ll need to adjust that based on the name of your date field.

IF(
   AND(
      {Deadline},
      NOW()>{Deadline}
   ), 
   "Past Due"
)

Here’s an outline of the formula logic:

  • If the {Deadline} field has a date entered
  • And that date is after the current date/time (signified by the NOW() function)
  • Then show the message “Past Due”
  • Otherwise, showing nothing

Hope that helps! I’d also recommend browsing through our formula resources here in our support center.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.