If anyone was interested in something similar, I was able to make a bit of a hack-around with a sub-table and a button(everyone seems to want me to put buttons everywhere, think its because you can’t in airtable 
).
- Make a sub-table with a column to link to rows on the main table and RowId column.
- Make a button to add Rows to the sub-table with the Row title as the link column value.
- Make a column with the list of sub-table rows with a look up, then add a sort based on the row id and slice the highest value.
Cheers,
