Has anyone come across a way to use ARRAYUNIQUE(values) in a ROLLUP so that it is case insensitive? E.g. a rollup of “Demo, DEMO, DeMo, demO” should return one value.
ARRAYUNIQUE(values)
+4
+29Welcome back to the Airtable community!
A workaroud would be to have a formula field in your original table that converts the original values to the same cause using either LOWER or UPPER. Then roll up that formula field.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.