Skip to main content

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

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

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'



Thanks Alexey!

Reply


Terms & Conditions