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.
Please try
IN( TEXT(MID( [ItemID] ,4, 1)) , LIST(“6”,“7”,“a”,“b”) )
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.
Yes, it seems to be an edge case where one of the two valid syntaxes of a function is misbehaving.
Thanks guys, that works. My wife appreciates that I stop swearing now.