Hi, I have a problem with my IF condition. Sc...

sumawa_quest
Participant III

Hi, I have a problem with my IF condition. Scenario, I want my apps to count the total visit to a certain places of interest based on email. So, I put this IF command inside the Virtual table:

=IF(AND([Visited?]=Visited, [Email]=USEREMAIL(), Yes,No))

but got this error:

Condition AND(([Visited?] = โ€œVisitedโ€), ([Email] = USEREMAIL()), โ€œYesโ€, โ€œNOโ€) has an invalid structure: subexpressions must be Yes/No conditions

Pls help. Tq in adv.

0 2 341
2 REPLIES 2

Lynn
Participant V

Hi @sumawa_quest Try moving one of your parenthesis to after USEREMAIL().

sumawa_quest
Participant III

Hi @Lynn Thank you very much. Its working.

Top Labels in this Space