Andrew_Schmitt - profile

Andrew_Schmitt · Apr 25, 2017

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 t...

Andrew_Schmitt · Dec 15, 2017

Also to be clear, I am not rolling up a date field. I’m rolling up text fields.

Andrew_Schmitt · Dec 15, 2017

Here’s a sample DB that I constructed that has the problem. Airtable Airtable: Organize anything you can imagine Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for f...

Andrew_Schmitt · Dec 15, 2017

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, ...

Andrew_Schmitt · Dec 15, 2017

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 t...

Andrew_Schmitt · Sep 25, 2017

I had exactly the same problem with rollup columns. Thread here. https://community.airtable.com/t/filter-is-empty-not-working-on-rollup-column/4290

User Statistics

User Activity

Filter "Is Empty" Not Working on Rollup Column

Re: Filter "Is Empty" Not Working on Rollup Column

Re: Filter "Is Empty" Not Working on Rollup Column

Re: Filter "Is Empty" Not Working on Rollup Column

Re: Filter "Is Empty" Not Working on Rollup Column

Re: Lookup field impossible to be blank?