I actually have the same issue. For me what i am trying to do is match a RowID to the user that’s viewing the ROW. (the signed in user.) Since Link to screen cant capture the current row. The issue i am finding is that the relation is set to the user that owns the row. And i want to set the row ID to myself (the sign in User)
For now i had no choice but to restrict the user that owns both rows in both sheet to only allow them to view for now. But what i want to allow is anyone in there org to be able to see each other rows. And i cannot do that as it will go to the other users row.
This is what i use for now. (I would like to use Company Name instead)
I was going to make a feature request that would allow me to add data to myself (Sign In user) instead of it going absolutely everywhere else. Annoying is hell. This needs to be added immediately. I am going nuts myself Anyone want to make a feature request i will vote for this. 