I am using a kanban view that has columns stacked by a single select field which denotes a freelancer’s name. Every new entry in the table denotes a new assignment, at which point I drag the assignment card to the respective freelancer stack. What I am looking for is a way to get Airtable to spit out a date to track the last time each stack was last given an assignment. I haven’t had any luck with the last modified field type because I cannot simple make that last modified dependent upon one field in every card because a stack could have numerous amounts of cards; but I also can’t make the last modified field dependent on the stack itself because that is technically a static piece of information.
My ultimate goal is for this data to show in a table where each freelancer (stack) value spitting out a date of last assignment figure based on the last time an assignment card was dropped in that respective stack, probably in an AT app later down the line once I figure out how to actually configure the data I am trying to solve for.
Keep in mind, I am not necessarily looking for how long each card has been in a stack, but rather how long it’s been since each stack had a new card dropped in it.
Thanks for any assistance in advance! Cheers!
