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

 


Reply