Next Reminder Date in Airtable ?

[ravikarwa]

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

	A	B	C	D	E
1	Q1	Q2	Q3	Q4	Next  Reminder
2	3/3/2024	6/6/2024	9/11/2024	11/11/2024	11/11/2024

Appreciate the help !

[TheTimeSavingCo]

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