Why "IF" in GoogleSheets works but in AppSheet not?

IN GOOGLESHEETS:

E6 = 01.01.2014

=IF(MONTH(E6) &"."& YEAR(E6) = (MONTH(NOW())) &"."& (YEAR(NOW())); 1; 2)

= 2

--------------

IN APPSHEET

"IF function is used incorrectly:the first input should be a condition that returns true or false."

 

 

0 2 55
2 REPLIES 2

Because the first argument isn't returning a true or false value, as the error message says. What is the Appsheet expression that you're trying to use?

https://help.appsheet.com/en/articles/2355953-if

I'd also recommend using the date-formatting capabilities of the TEXT() expression.

https://help.appsheet.com/en/articles/3517328-text

 

Hm, I have added 2 parentheses before IF only, and all stay to be right, and no more errors.. Maybe Appsheet has any own format of this formula? 

Bad: =IF(MONTH(E6) &"."& YEAR(E6) = (MONTH(NOW())) &"."& (YEAR(NOW())); 1; 2)

Good: =IF((MONTH(E6) &"."& YEAR(E6)) = (MONTH(NOW())) &"."& (YEAR(NOW())); 1; 2)

Top Labels in this Space