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