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."
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)
User | Count |
---|---|
36 | |
32 | |
30 | |
18 | |
16 |