Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here


Topic Labels: Formulas
458 1
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

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 LOWER or UPPER. Then roll up that formula field.