Forum Discussion
New Column Lookupvalue with a filter on another Tab
Hi together, I have to check if in the table "data_Current" the email is matching with an email in the table "users" and it should only match when the User in the table "users" does have an model ...
amitchandak
Super User
Super UserAnonymous ,
new column= var _1 = count(User, current_date[email] = user[email]),user[email])
return
if(isblank(_1) , "No", "Yes")
Hi,
as you can see in the Solution. User test.1 & test.3 & test.100 should be Yes.
I have updated the description with one picture, maybe this help