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.
Hi @sumawa_quest Try moving one of your parenthesis to after USEREMAIL().
Hi @Lynn Thank you very much. Its working.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |