IN(LOOKUP(USEREMAIL(), โUsersโ, โUSER_EMAILโ, "DPT_NOโ),{10})
I think the problem has to do with the DPT_NO column being an EnumList, Ref because other columns with different data types all work. What am I missing?
This works: LOOKUP(USEREMAIL(), โUsersโ, โUSER_EMAILโ, "VIEWโ)=โSimpleโ
and this: LOOKUP(USEREMAIL(), โUsersโ, โUSER_EMAILโ, "PI_NOโ)>15
Thank you.
Solved! Go to Solution.
Iโd try this one
What is the expression supposed to be checking, in English? Because it doesnโt make much sense how you have it written. IN wants a single value as first argument, and a list as second. Youโve given it a possible list as first, and a list of a single item as second. huh?
I can never remember how LOOKUP() returns when you ask it to return a List, but you could try one of the following options depending on exactly what you answer for the above.
LOOKUP(โฆ) = 10 (or maybe โ10โ)
CONTAINS( LOOKUP()โฆ) , โ10โ )
CONTAINS( CONCATENATE( LOOKUP(โฆ)) , โ10โ)
IN( 10 , LOOKUP(โฆ) )
IN( 10 , SPLIT( LOOKUP(โฆ) , โ,โ) )
Thanks Marc. Iโm want to show the view if DPT_NO contains the value of 10. DPT_NO can have one or more values.
Iโd try this one
That worked. Thank you!
hey @Steve , just saw you liked this post. Can I get your wisdom on the above comment. Remember something written elsewhere about certain data Types running through LOOKUP/ANY that maybe get converted. Or am I making stuff up?
Oh, that you specifically recommended IN(..., LOOKUP(...))
suggested to me LOOKUP() behavior has recently changed. In my experience, LOOKUP() would only return singular values, so lists would have to be SPLIT() to get to their values. That @Lucinda_Mason marked your suggestion as the solution and said it worked tells me SPLIT() is no longer needed.
Good to hear I didnโt completely make it up. I also tested it in my test app, and was surprised that it worked.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |