At least I think itโs simple.
Hereโs the syntax:
LOOKUP(โTech Emailโ, โTechโ, โEmailโ, โTech IDโ). Ah! So frustrated. The minute I think I understand itโฆ
Solved! Go to Solution.
Assuming the green table is called Users
Any(Select(Users[Tech ID],[Email]=[_ThisRow].[Tech Email]))
Assuming the green table is called Users
Any(Select(Users[Tech ID],[Email]=[_ThisRow].[Tech Email]))
Hallelujah. That worked! Thank you.
Read about the other options here - https://help.appsheet.com/en/articles/961274-list-expressions-and-aggregates
help.appsheet.com is your friend
Wow! Thank you.
User | Count |
---|---|
42 | |
29 | |
28 | |
14 | |
14 |