I need a formula which can display which checkbox which was modified FIRST.
my idea was to create multiple checkboxes for multiple staff, and we need a way to see which staff ticked their checkbox FIRST and display that as a field.
So multiple checkboxes [E.G Adam, Su, Ivy]
then a last modified field for each of these checkboxes.
Then a custom formula which can see which one of these last modified fields is the OLDEST down to the second.
One problem i forsee if they happened within the same second, does airtable deal with nanoseconds?
Any help would be appreciated