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.