invalid data validation constraint

[Mrak123]

Hi All, 

I'm having some issues with a Valid_if formula under the Data Vadility dropdown for one of my columns. the exact error i'm getting is:

Column Name 'Barcode' in Schema 'Received_Schema' of Column Type 'Number' has an invalid data validation constraint '=IFS( [BARCODE]=ANY(SELECT(Backup[Barcode],([Barcode]=(MAXROW("Backup","_ROWNUMBER",[Listing User Email]=USEREMAIL())))))+1,"YES" )'.

The formula i'm trying to use is:

IFS(
[BARCODE]=ANY(SELECT(Backup[Barcode],([Barcode]=(MAXROW("Backup","_ROWNUMBER",[Listing User Email]=USEREMAIL())))))+1,"YES"
)

I have read some comments on other threads about making sure any columns that are enum or enumlist have "allow other values" on. But none of the columns referenced in this equation are enum or enumlist.

Any ideas would be a great help, thanks 👍

[AleksiAlkio]

I assume your Barcode column is a number column. Try to use..
[BARCODE]=ANY(SELECT(Backup[Barcode],[Barcode]=MAXROW("Backup","_ROWNUMBER",[Listing User Email]=USEREMAIL())))+1

But.. it sounds your Barcode column is a key column and then you could use just..
[BARCODE]=MAXROW("Backup","_ROWNUMBER",[Listing User Email]=USEREMAIL())+1