MATCH now supports modifiers
FormulasThe MATCH formula function now supports modifiers like "i" to make the match case insensitive.
MATCH("foobar", "[A-Z]", "i")The list of new modifiers matches the Ruby modifiers here.
See our documentation for more information.