I have two linked tables A & B
A contains different projects
B is where staff is logging different tasks linked to different project at different dates.
I’m trying to roll up a the latest logged task for each project back in A.
I tried rolling up MAX(values) but it only works on dates, so will not show the latest task field back in A.
Is there any way to rollup a field based of the latest date?