Can someone suggest why this statement, used exactly as it is below in all my AppSheets, will find a particular USERMAIL() address in some AppSheets but not all, when logged in with that USERMAIL() address?
=CONCATENATE(LOOKUP(USEREMAIL(), NurseIDs, Email, ID),[NextNum])
I’d be happy to share one AppSheet where it does and the other where it does not, but not sure how to do that.
The LOOKUP expression will always give you a result with one value. It’s the same than ANY(SELECT(…)) but with simple syntax. It will find the first one from your table.
I found that there were two NurseIDs tables. One, being older, did not have the new nurse’s ID. Strange thing is, I don’t recall ever creating a second table.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |