2Table selects

[SKy0939]

hello, I am a new student, I would like to ask if I have Table A and Table B, Table A has A1, A2, A3 Table B has B1, B2, I need to show it only when it meets the conditions in show if, Now the completed grammar can't be completed, need to add [A1]=[B1], how can I do it? count(select(A[A1],and(count(select(B[B1],[A2]=USEREMAIL()))=1,[A3]="TRUE")))=1

[Joseph_Seddik]

Hello,

People would be better able to help you if can just explain your requirement in plain language, rather than writing the expression, which is not clear. Thanks.