Hi community,
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
Julien:
Is there something I missed with that formula?
Probably.
It seems that the when the ANY() formula renders blank, the LINKTOROW() formula shows a randomly row of the table. I expected that the LINKTOROW() would just do nothing in that specific case. Could you tell why AS behaves like that?
Thanks
My guess is that “the quirk” is biting you:
Indeed, it seems to be something like that!
Thanks Steve!