where i mistake in function suggest me

AppSheet AppSheet Q&A
, , ,
1

Can you explain where i mistake in function.

IFS(
  NOT(
  COUNT(
    FILTER(CAMPUS SCAN SHEET, [Shelf Code] = [_This]) - LIST([_ThisRow])
  ) >= 24,"Duplicate Shelf Code",

  NOT(OR(
  AND(
    startswith([SHELF CODE],"MCOP-"),
    LEN([SHELF CODE]) = 8
  ),
  AND(
    startswith([SHELF CODE],"MCUP-"),
    LEN([SHELF CODE]) = 8
  ),
  AND(
    startswith([SHELF CODE],"FKSOP-"),
    LEN([SHELF CODE]) = 9
  ),
AND(
    startswith([SHELF CODE],"FKSUP-"),
    LEN([SHELF CODE]) = 9
),AND(
    startswith([SHELF CODE],"HOLD"),
    LEN([SHELF CODE]) = 7),
AND(
    startswith([SHELF CODE],"ADJUST"),
    LEN([SHELF CODE]) = 11),
AND(
    startswith([SHELF CODE],"MD-"),
    LEN([SHELF CODE]) = 5)))
),"Invalid Shelf code"
)))
2

Try this:

IFS(
		NOT(
  		COUNT(
    		FILTER(CAMPUS SCAN SHEET, [Shelf Code] = [_This]) - LIST([_ThisRow])
  		) >= 24
    ),
    "Duplicate Shelf Code",

	  NOT(
    	OR(
		  	AND(
  	  		startswith([SHELF CODE],"MCOP-"),
    			LEN([SHELF CODE]) = 8
 	  		),
		  	AND(
  	  		startswith([SHELF CODE],"MCUP-"),
    			LEN([SHELF CODE]) = 8
	 		 	),
		  	AND(
  	  		startswith([SHELF CODE],"FKSOP-"),
    			LEN([SHELF CODE]) = 9
	  		),
				AND(
    			startswith([SHELF CODE],"FKSUP-"),
    			LEN([SHELF CODE]) = 9
				),
  	    AND(
    			startswith([SHELF CODE],"HOLD"),
    			LEN([SHELF CODE]) = 7
	      ),
				AND(
    			startswith([SHELF CODE],"ADJUST"),
    			LEN([SHELF CODE]) = 11
	      ),
				AND(
    			startswith([SHELF CODE],"MD-"),
    			LEN([SHELF CODE]) = 5
      	)
			)
		),
		"Invalid Shelf code"
)
3

Showing error

Screenshot_20220508-223043440~2.jpg
Screenshot_20220508-223043440~2.jpg2160Ă—610 124 KB

4

Try this:

IFS(
NOT(
COUNT(
FILTER(CAMPUS SCAN SHEET, [Shelf Code] = [_This]) - LIST([_ThisRow])
) >= 24
), “Duplicate Shelf Code”,
NOT(
OR(
AND(
STARTSWITH([SHELF CODE],“MCOP-”),
LEN([SHELF CODE]) = 8
),
AND(
STARTSWITH([SHELF CODE],“MCUP-”),
LEN([SHELF CODE]) = 8
),
AND(
STARTSWITH([SHELF CODE],“FKSOP-”),
LEN([SHELF CODE]) = 9
),
AND(
STARTSWITH([SHELF CODE],“FKSUP-”),
LEN([SHELF CODE]) = 9
),
AND(
STARTSWITH([SHELF CODE],“HOLD”),
LEN([SHELF CODE]) = 7
),
AND(
STARTSWITH([SHELF CODE],“ADJUST”),
LEN([SHELF CODE]) = 11
),
AND(
STARTSWITH([SHELF CODE],“MD-”),
LEN([SHELF CODE]) = 5
)
)
), “Invalid Shelf code”,
TRUE, “Unknown error.”
)

2 Likes
5

Thank u @Joseph_Seddik @Amine

2 Likes