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
Maybe this?
Probably that is the answer. I haven’t seen that. Thank you!
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.
Please post screenshot of the error.
Error is the same
“LEN function is used incorrectly”
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())
)
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
User | Count |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |