Hi all !
I have 2 tables (N°1 and N°2)
I have an automation on the N°1 that creates record (named tasks) in the N°2
On the N°2, I have a checkbox field for each records it creates.
I’d like on the N°1 add a rollup or a formula that displays the latest checkbox that has been validated on the N°2.
Right now, im able to display the unchecked checkbox using rollup - but I can’t find a solution to only display the latest checked task. Do you have any recommendation ? thanks !
Finding the latest record (or the latest record matching certain criteria) is a common request, and the solution already exists in several places in the forum. Here’s the most recent time I’ve written about it. You should be able to adapt this concept to your situation pretty easily: