Show latest checkbox

[Alter345]

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 !

[Justin_Barrett]

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:

Get last/newest linked record Ask the community

@Brian_Hendel It’s all done at the function level. No scripting required. Step 1: Find the time of each product’s latest order Finding the latest order will require some precision. If you have a field to capture the order date, that won’t be sufficient unless it also captures the time. Change that date field’s properties to add the time if it’s not already set; if you don’t yet have such a field, then a “Created time” field will suffice. Whichever option you use, I’ll call this field {Created} …

[Alter345]

Hello !
I did check the forum before posting and tried many things …
I will try your example
many thanks for your help.