select() with in()

[Tragertt]

I need some code to combine a select() with an in() and im not sure how to do that. I need something like this

select(users[site], [site] = in([_thisrow].[sites]))

That is not working and I have tried many variations but what I would like is the second part where the value of [site] = anywhere listed in the other field [sites].

Any ideas?

[Joseph_Seddik]

Follow the syntax in the documentation:

IN([element], [List of elements]) 

IN() - AppSheet Help

[James_Burns · Accepted solution]

Check the documentation for IN(), your syntax is incorrect. Try

SELECT(users[site],IN([site],[_THISROW].[sites]))