Help

How to get the last and previous date from a list?

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
1196 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Eugenek
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Screenshot 2023-09-29 at 23.09.05.png

1 Solution

Accepted Solutions
Alexey_Gusev
13 - Mars
13 - Mars

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'


See Solution in Thread

3 Replies 3
Alexey_Gusev
13 - Mars
13 - Mars

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'


There is no FILTER in the Airtable

Thanks Alexey!