LEN() function error

AppSheet AppSheet Q&A
,
1

Hi there,
I am trying to put a LEN() formula inside of the IF() but this error appears:
“LEN function is used incorrectly”
Formula looks like this:
IF(
AND(
LEN([Z])=7;
IN([Z],xyz[Z]));
[A]<>“B”;
[A]=“A”
)
Am I doing sth wrong? It htis article:

the LEN() formula looks the same. Cannot find the solution. Please help me guys.
Mat

2

Maybe this?

[Why the Len() Error when using it with or() or and()?](https://community.appsheet.com/t/why-the-len-error-when-using-it-with-or-or-and/48935/2) Questions

I would guess SecondColumn is not of a textual type. [image] Mmmm… Not really. Read more: https://community.appsheet.com/search?q=@steve%20quirk Have you seen these?

2 Likes
3

Probably that is the answer. I haven’t seen that. Thank you!

2 Likes
4

Ups, sorry guys but it is not the answer. This column now is a text and still the same error. I have no more ideas.

1 Like
5

Please post screenshot of the error.

6

Error is the same

“LEN function is used incorrectly”

7

hi, Did you find the solution? I have the same problem "“LEN function is used incorrectly”

if(
len(month(today()))=1,
“0”&month(today()),
month(today())
)

8

Hi Again… I’ve found the solution

if(
len(TEXT(month(today())))=1,
“0”&month(today()),
month(today())
)

the field must be text… I added TEXT() function to convert number to text