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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.