Ref column using a google sheet table

[tintin007]

Hi,

I have a couple apps one using appsheet created table and the other using googlesheet table. My trouble seems to be that de-referencing does not work when using the same principle of ref columns with the google sheet table. Is there something different i need to do ? I did a search in here but couldnt see a solution

Appsheet set up

[User].[Email]=Useremail()  This works and returns the correct user email

using google sheet table

[User].[User Email]=Useremail()  returns false 

would a show if expression used in a view affect the way the above works

Index(SELECT(User Role[CURRENT USER], ([Role ID] = Index(Current User[Role ID], 1))), 1)

the only difference i can make out between the two apps is the addition of the user role table.

hope that makes some sense,

Cheers