IF formula assistance using dates

Question

Hello! I'm creating an Airtable base to manage book club meetings. I have a column for the meeting dates (DD/MM/YYYY) which take place once per month. I'd like to have a "Reading Status" column that uses a formula to create the following labels:

"All Done" for meetings where the date has already passed
"Up Next" for the upcoming meeting
"Not Yet Read" for future meetings that are not the next closest meeting

I am new to formulas and struggling with how to set this up. Any help would be much appreciated. Thank you!

TheTimeSavingCo · Accepted Answer

Finding out which record is "Up Next" isn't possible with just a formula field I'm afraid. To get the upcoming meeting you're going to need to create a linked field to another table and do calculations to figure out which meeting is the upcoming one

"All Done" and "Not Yet Read" are easily done with formulas though!

IF(
  IS_BEFORE(
    DATETIME_PARSE(
      {Date in Text},
      "DD/MM/YYYY"
    ),
    TODAY()
  ),
  "All Done",
  "Not Yet Read"
)

(If your date is in a Date type field you can just remove the "DATETIME_PARSE" bit)

Thank you so much! The formula worked.

soupdawg22 · Answer

Finding out which record is "Up Next" isn't possible with just a formula field I'm afraid. To get the upcoming meeting you're going to need to create a linked field to another table and do calculations to figure out which meeting is the upcoming one

"All Done" and "Not Yet Read" are easily done with formulas though!

IF(
  IS_BEFORE(
    DATETIME_PARSE(
      {Date in Text},
      "DD/MM/YYYY"
    ),
    TODAY()
  ),
  "All Done",
  "Not Yet Read"
)

(If your date is in a Date type field you can just remove the "DATETIME_PARSE" bit)

Thank you so much! The formula worked.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded