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

expressions
(sumawa quest) #1

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.

#2

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

(sumawa quest) #3

Hi @Lynn Thank you very much. Its working.