Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

ARRAYUNIQUE(values)

Topic Labels: Formulas
1934 1
cancel
Showing results for 
Search instead for 
Did you mean: 
nnnnneil
8 - Airtable Astronomer
8 - Airtable Astronomer

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.