Comparing start date of this record to end date of...

[Eugenek]

Hi, does anyone have any ideas on how to write a formula to mark a previous date for each person?

[Alexey_Gusev · Accepted solution]

Hi,
it depends on how do you mark first/last.
Working with totals and such kind of values (min/max, first/last) that dynamically changing with new records (like if you add Jony with 1 Ocftober, it became Last date, and 1st record with 30 Sep 14:00 became Previous) - requires linked table with Names. All totals etc (first last) calculated via rollups. for previous you just can add another rollup  MAX(values)' filtered by 'Status is not Last date'

[Eugenek]

There is no FILTER in the Airtable

[Eugenek]

Thanks Alexey!