The 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.
MATCH now supports modifiersThe 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.