where i mistake in function suggest me

[Sayad]

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"
)))

[Amine]

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"
)

[Sayad]

Showing error

 

[Joseph_Seddik · Accepted solution]

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."
)

[Sayad]

Thank u @Joseph_Seddik @Amine