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"
Solved! Go to Solution.
This?
LOOKUP([_THISROW].[UserID],"PERSONS","UserID","Owner")
Thank you Suvrutt! It worked.
This?
LOOKUP([_THISROW].[UserID],"PERSONS","UserID","Owner")
Thank you Suvrutt! It worked.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |