Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Next Reminder Date in Airtable ?

Topic Labels: Formulas
199 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ravikarwa
4 - Data Explorer
4 - Data Explorer

Hi All, I am trying to build a Reminder portal to track some key dates within Airtable and was wondering how in Airtable can I use Formula or if there is any other way to find the date that is due to come from a range of dates (sample data below - I can use the MINIFS function - =MINIFS(A1:D2, A1:D2, ">"&TODAY()) in excel to find the smallest date that is greater than today's date). But how do I achieve this in Airtable ? I couldn't find the Minifs formula function in Airtable

 

 ABCDE
1Q1Q2Q3Q4Next  Reminder
23/3/20246/6/20249/11/202411/11/202411/11/2024

Appreciate the help !

1 Reply 1

Does this look right?

Screenshot 2024-09-13 at 8.19.52 AM.png

DATETIME_PARSE(
  MIN(
    IF(
      IS_AFTER(
        Q3,
        TODAY()
      ),
      DATETIME_FORMAT(
        Q3,
        'x'
      ) + 0,
      999999999999999999
    ),
    IF(
      IS_AFTER(
        Q4,
        TODAY()
      ),
      DATETIME_FORMAT(
        Q4,
        'x'
      ) + 0,
      999999999999999999
    )
  ),
  'x'
)