This expression TRUE But not work

AppSheet AppSheet Q&A
, , , ,
1

Suggest me why not work this function.

89.PNG
89.PNG969×137 5.02 KB

Capture.PNG
Capture.PNG1092×132 5.7 KB

OR(
  AND(
    startswith([SHELF CODE],"MCOP-"),
    LEN([PUTWAY NO]) = 8
  ),
  AND(
    startswith([SHELF CODE],"MCUP-"),
    LEN([PUTWAY NO]) = 8
  ),
  AND(
    startswith([SHELF CODE],"FKSOP-"),
    LEN([PUTWAY NO]) = 9
  ),
AND(
    startswith([SHELF CODE],"FKSUP-"),
    LEN([PUTWAY NO]) = 9
),AND(
    startswith([SHELF CODE],"HOLD"),
    LEN([PUTWAY NO]) = 8),
AND(
    startswith([SHELF CODE],"ADJUST"),
    LEN([PUTWAY NO]) = 11))

ANY of these statements is true:
....1: ALL these statements are true:
........1: (The value of column 'SHELF CODE') starts with the text value ("MCOP-")
........2: (The text length of (The value of column 'PUTWAY NO')) is equal to (8)
....2: ALL these statements are true:
........1: (The value of column 'SHELF CODE') starts with the text value ("MCUP-")
........2: (The text length of (The value of column 'PUTWAY NO')) is equal to (8)
....3: ALL these statements are true:
........1: (The value of column 'SHELF CODE') starts with the text value ("FKSOP-")
........2: (The text length of (The value of column 'PUTWAY NO')) is equal to (9)
....4: ALL these statements are true:
........1: (The value of column 'SHELF CODE') starts with the text value ("FKSUP-")
........2: (The text length of (The value of column 'PUTWAY NO')) is equal to (9)
....5: ALL these statements are true:
........1: (The value of column 'SHELF CODE') starts with the text value ("HOLD")
........2: (The text length of (The value of column 'PUTWAY NO')) is equal to (8)
....6: ALL these statements are true:
........1: (The value of column 'SHELF CODE') starts with the text value ("ADJUST")
........2: (The text length of (The value of column 'PUTWAY NO')) is equal to (11)
2

Where are you using this expression?

Why do you say it is not working? What is the result you are getting and what is the result you were expecting?

1 Like
3

in the valid if.

4

post a screenshot showing both the shelf code and putaway no columns.

1 Like
5

Sorry my mistake. i solved this.

i replaced putaway no to shelf code.

thank you for reply @Joseph_Seddik

2 Likes