Showing Error Need Help

[Sirfyaad]

i don't know! what is missing in this. but showing this error "Ops Something is Wrong, Please Scan Again" No entry is happening from my appsheet app. This error is showing again and again. how can fix this error. need help.

entry locked

Valid If formula for column AWB NO (Yes/No,List)

AND(
  OR(
    NOT(IN([_THIS], SCAN SHEET[AWB NO])),
    NOT(IN([_THIS], SHEET1[AWB NO])),
    NOT(IN([_THIS], SHEET2[AWB NO]))
  ),
  [_THISROW_BEFORE].[AWB NO] = [_THISROW_AFTER].[AWB NO],
  LEN([AWB NO]) > 6,
  NOT(
    OR(
      CONTAINS([_This], "CRP"),
      CONTAINS([_This], "~"),
      CONTAINS([_This], "&"),
      CONTAINS([_This], "_"),
      CONTAINS([_This], "MYNR0"),
      CONTAINS([_This], "/"),
      CONTAINS([_This], "CAMPU"),
      CONTAINS([_This], "SB"),
      CONTAINS([_This], "DLVP"),
      CONTAINS([_This], "RVPMF"),
      CONTAINS([_This], "BS0"),
      CONTAINS([_This], "SF1")
    )
  )
)

Error_Message_If_Invalid formula for column AWB NO (Text)

IFS(
  AND(
    IN([_THIS], SCAN SHEET[AWB NO]),
    [_THISROW_BEFORE].[AWB NO] <> [_THISROW_AFTER].[AWB NO]
  ),
  "Already Scanned On " & 
    SELECT(CAMPUS SCAN SHEET[DATE], [AWB NO] = [_THISROW].[AWB NO]),

  AND(
    IN([_THIS], SHEET1[AWB NO]),
    [_THISROW_BEFORE].[AWB NO] <> [_THISROW_AFTER].[AWB NO]
  ),
  "Already Scanned On " & 
    SELECT(SHEET1[DATE], [AWB NO] = [_THISROW].[AWB NO]),

  AND(
    IN([_THIS], SHEET2[AWB NO]),
    [_THISROW_BEFORE].[AWB NO] <> [_THISROW_AFTER].[AWB NO]
  ),
  "Already Scanned On " & 
    SELECT(SHEET2[DATE], [AWB NO] = [_THISROW].[AWB NO]),

  NOT(
    OR(
      CONTAINS([_THIS], "CRP"),
      CONTAINS([_THIS], "~"),
      CONTAINS([_THIS], "&"),
      CONTAINS([_THIS], "_"),
      CONTAINS([_THIS], "MYNR0"),
      CONTAINS([_THIS], "/"),
      CONTAINS([_THIS], "CAMPU"),
      CONTAINS([_THIS], "SB"),
      CONTAINS([_THIS], "DLVP"),
      CONTAINS([_THIS], "RVPMF"),
      CONTAINS([_THIS], "BS0"),
      CONTAINS([_THIS], "SF1")
    )
  ),
  "Ops Something is Wrong, Please Scan Again"
)