Can anyone provide me with the formula to filter the records based on the assignee mail. As assignee is kind of a compound filed I am unable to find a way to extract the mail and pass it in the filter by formula method. Thanks in advance