I am stuck on this for a while. Any guidance to write this expression would be helpful.
I am trying to restrict the users to view a list of projects from the PROJECTS table if these projects are in the comma-separated list in the STAFF table.
- Users should see related projects
- Reference should work.
With the formula below, I get yellow exclamation marks. If I chose a key and a label both for PROJECT_NAME exclamation marks are disappear but then I would have duplicates ID’s in my DATA table.
DATA[PROJECT] column is ref type to PROJECT and Valid_if expression is.
SPLIT( SELECT( STAFF[PROJECTS], USEREMAIL()=EMAIL,), "," )