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.
Welcome 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
UPPER. Then roll up that formula field.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.