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.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |