
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 25, 2017 05:39 PM
I’ve used a Rollup column to aggregate data from another table. There are duplicates in the data being aggregated, as well as blanks. I use the ARRAYUNIQUE(values) to operate on the roll up data. I even created an adjacent cell with an IF statement to test for ISBLANK and it is being returned as being blank.
Once I set a filter the Rollup column to not show empty cells, empty cells are still shown. The issue is in the only DB in my account, in the Organization tab.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2017 08:34 AM
I am guessing there is something different about the results of a rollup column. I also just noticed if I try to make a calendar view I cannot use the dates in a rollup column to act as the dates for the calendar. Only native dates on the table are accepted.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 15, 2017 08:10 AM
I’m bumping this.
I’m rolling up results of a column where EMPTY() is used to define the cell. The result is a cell that appears to be empty. Yet if I filter records with “Is Empty” these records are still shown. Let me know if anyone would like me to walk them through the issue.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 15, 2017 08:41 AM
Can you share a version of the base? Or a copy with some data? It is hard to say without being able to see the data types and formatting. But…
Have you tried using BLANK() instead of EMPTY()? I am not familiar with EMPTY(), to be honest, but all my efforts with BLANK() work quite well with Rollups.
Also, what Rollup function are you using for the dates? I have a calendar that works with a Rollup of MAX(values) to get the max date for a given record. If your date field is computed you may need to check that the resulting format is actually being read as a date (I know this sounds dumb but sometimes it really is an issue like this!).
Hope some of this was helpful.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 15, 2017 09:38 AM
Sorry - I am using BLANK().
I have a column in a table (SUBSCRIPTIONS) that returns a another column or BLANK() depending on the date.
IF(IS_AFTER({Expires}, TODAY()),{Report Code},BLANK())
When I roll up that column on another Table Tab (COMPANIES, Active Services column) the results are as I expect. I use the ARRAYUNIQUE(values)
function to create an array. Some of those arrays are multiple entries that are rolling up BLANK()
results.
But when I then filter the records in COMPANIES for records where the Active Services “is not empty” these records which are an ARRAYUNIQUE
of EMPTY()
values are still visible.
I would rather not share the database with a non-Airtable employee as we use it for production functions. But I could create a sample of the failure.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 15, 2017 09:53 AM
Here’s a sample DB that I constructed that has the problem.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 15, 2017 09:54 AM
Also to be clear, I am not rolling up a date field. I’m rolling up text fields.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 15, 2017 09:54 AM
Are these dates just text?
To clarify, these will need to be formatted as dates somewhere in the process if you want the Calendar view to recognize them.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 25, 2024 12:17 PM
My workaround was to accentuate the logic in the rollup field with text:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 30, 2025 08:13 AM
I just tried this and IF(ARRAYUNIQUE(values)=BLANK(),"", ARRAYUNIQUE(values)) has the same effect and leaves the cell actually empty rather than displaying "blank"
