Show values based on user list

[Atlas]

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.

1. Users should see related projects
2. 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,),
             ","
           )