Lookup a user-specific column

Is it possible to do a relation and then lookup the value in a user-specific column?
Pull data from Sheet B (which is a user-specific column) into Sheet A.

From the surface it appears it is not possible, as it is impossible to establish a relation between the 2 sheets.

It appears the connection to know which value belongs to which user is deep in Glide and not accessible to formula manipulation.

Just create a template column in each table that contains the email address or UserID of the signed in user, and use those two columns to build the relation.

3 Likes