Security Filter

[shuklas]

I have imported the file list from Google drive into Google sheet with Name, URL, Folder Path, Created Time, Modified Time, MIME Type and Size (Bytes) columns. I have added one more sheet called Sheet 2 into same Google sheet and added columns as Name, Email, Role and Folder Path. Objective of this sheet is to define which user role has access to which folder path (at what folder level). I have imported these two tables into Google App Sheet. I need to apply validation that if current logged in user has 'Leadership' or any other role mentioned for that matter under role column in Sheet2 then based on the folder path mentioned for the role it should display data from Sheet 1? I tried a lot of things but to no avail because there is no email column in the sheet populated from Google drive. Would really appreciate if you could help

[Steve]

This?

IN(
  [Folder Path],
  SELECT(
    Sheet 2[Folder Path],
    AND(
      ISNOTBLANK([Role])
      (USEREMAIL() = [Email])
    )
  )
)