Help

IF formula assistance using dates

Topic Labels: Formulas
Solved
Jump to Solution
673 2
cancel
Showing results for 
Search instead for 
Did you mean: 
soupdawg22
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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!

Screenshot 2024-03-14 at 10.46.18 AM.png

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)

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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!

Screenshot 2024-03-14 at 10.46.18 AM.png

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.