"LIST has elements of mismatched types"

[santacruzJam]

How can I get around this error?  

IN(TEXT(MID([ItemID],4,1)),{"6","7","a","b"})

[ItemID] is a UniqueID, so could be either a number or a letter.

Trying to look at the 4th character and perform an operation.  It seems to always force the character to a number.   If I just do numbers and leave the quotes off, it is fine and same with letters, but not what I want to do.  Not sure why the TEXT() does not seem to do anything with numbers.  

[Suvrutt_Gurjar]

Please try 

IN( TEXT(MID( [ItemID] ,4, 1)) , LIST("6","7","a","b") )

[Marc_Dillon · Accepted solution]

It's not about the 4th character from ItemID, it's about the list.

Looks like a minor edge-case bug to me, where when using curly-brace notation for lists, if the first item is a number, even if in quotes, it assumes all items are numbers? So you can either change it to {"a","b","6","7"} or LIST("6","7","a","b")

And the TEXT() portion should be unnecessary.

[Suvrutt_Gurjar]

Yes, it seems to be an edge case where one of the two valid syntaxes  of a function is misbehaving.

[santacruzJam]

Thanks guys, that works.   My wife appreciates that I stop swearing now.