Hello, how can i get the slice of my googlesheet base on another sheet by useremail()?

AppSheet AppSheet Q&A
1

i need to get the slice of this.. data[name].. by another sheet of Ref_sdo[name] with email.. by useremail()? i need to show the user their own data by their own email address

sheet 1 = data[name]

sheet 2 = Ref_sdo[name] and another “column [email]”

to show the user its own data by useremail?? please help me!

2

Hi @Moicz

You may want to have a look to this expression:

LOOKUP()

It could be:

[name]=LOOKUP(USEREMAIL(),"Ref_sdo", "Email","Name")
2 Likes
3

thank you so much!!!

2 Likes