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 !