@darklilcorner Your original version lacks a closing parenthesis in each of the expressions:

(UPPER(SUBSTR({entityid}, 1, 4)) = 'IR -' THEN 'Ireland Subsidiary'

Three

(

and only two

)

— hence, “invalid expression.”

absolutely marvelous! 😭 I really am such an idiot

No, you are not! We all do this. It just takes a second set of eyes. Trust me, before long, I’ll be asking you to be my second set.