Hello,
While entering a new record or editing an old one, I want AppSheet to tell me if an email exists in another sheet. Below is what I thought would work, but it doesn't seem to be checking as emails I have entered are in the other sheet.
IN(UPPER(IDKey[Email]),LIST(UPPER(StateOfMichiganCompleted[Email Address])))
Your suggestions are very much appreciated!
Daryl
p.s. @Marc_Dillon something tells me you'll have the answer ๐
Solved! Go to Solution.
Try something like..
IN([Email],StateOfMichiganCompleted[Email Address])
Try something like..
IN([Email],StateOfMichiganCompleted[Email Address])
Thanks @AleksiAlkio!
I believe that StateOfMichiganCompleted[Email Address] is already a list, so perhaps this will work if you just eliminate the List function.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |