Hi, does anyone have any ideas on how to write a formula to mark a previous date for each person?
Solved
How to get the last and previous date from a list?
+3Best answer by Alexey_Gusev
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'
+25Hi,
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'
+3There is no FILTER in the Airtable
+3Hi,
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'
Thanks Alexey!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.