Replace Useremail() with Name

AppSheet AppSheet Q&A
1

I have a table “PERSONS” listing users of an app; columns as follows -

_rownumber, UserID (i.e. email), Owner (i.e. name of the user)

In another table, the users add tasks. Each row of that table captures UserID i.e. Initial Value = Useremail()

For the next column, when I use the formula LOOKUP([UserID],“PERSONS”,“UserID”,“Owner”), it does not return the Owner according to the User ID, instead, it always returns the name of the first person in the table “PERSONS”

2

This?

LOOKUP([_THISROW].[UserID],“PERSONS”,“UserID”,“Owner”)

https://help.appsheet.com/en/articles/2357309-lookup

2 Likes
3

Thank you Suvrutt! It worked.

2 Likes