Linktorow()

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

Probably.

1 Like

:rofl:

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:

https://community.appsheet.com/search?q=@steve%20quirk

Indeed, it seems to be something like that!

Thanks Steve!

1 Like