Can someone suggest why this statement, used ...

[Daryl_Zernick]

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.

[Aleksi_Alkio]

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.

[Daryl_Zernick]

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.