How to filter linked data [SOLVED]

[Angie_Belle]

I buy pallets, which each have several items on them, so I have a table for each LOT (pallet), and a table of items. I have a linked column in the LOTS table, which pulls the names of each ITEM in that lot. I would like to have another column that pulls only those ITEMS which has not been marked SOLD.

Ideas?

[Elias_Gomez_Sai]

No prob! Maybe other advanced users like @W_Vann_Hall or @Jeremy_Oglesby have any tricky suggestion for you :grinning_face_with_sweat:

[Andy_Lin1]

Building off of @Elias_Gomez_Sainz’s solution:
Replace the formula in the “Pending” field with IF(Sold,BLANK(),{Item Name})
Replace the formula in the Rollup field with ARRAYCOMPACT

What this does is produce a column on your Items table with the names of items that haven’t yet been sold. The Lots table then rolls up these names, and discards the BLANK() entries (which correspond to sold items).

The formatting might be a little bit wonky (I’m not sure if it’ll space things out correctly), but it should get you what you need.

[Angie_Belle]

This worked GREAT!

Thank you very much. :slightly_smiling_face: