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 |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |