Return mail adress on two conditon (search in enumlist)

Try

SELECT(
 STAFF[E-MAIL],
 AND(
  [POST] = "PROJECT MANAGER",
  IN(
   [_THISROW].[SITE],
   [PROJECTS]
  )
 )
)
3 Likes