Skip to main content

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 !

Does this look right?



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' )