Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 12, 2020 03:22 PM
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

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 12, 2020 03:44 PM
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.
Reply
