LINKTOROW(ANY(SELECT(Lube Follow up[Unique ID],AND(
[LubePointTask ID]=[_THISROW].[LubePointTask ID],[Status]=“To do”))),
“Lubricator Details (Route)”)
That formula does not link to the expected row of Lube Follow up table.
Is there something I missed with that formula?
Thanks for your help