Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

How to filter linked data [SOLVED]

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Angie_Belle
6 - Interface Innovator
6 - Interface Innovator

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?

14 Comments
Elias_Gomez_Sai
13 - Mars
13 - Mars

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
9 - Sun
9 - Sun

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
6 - Interface Innovator
6 - Interface Innovator

This worked GREAT!

Thank you very much. :slightly_smiling_face:

Status changed to: Already in product
MaddieJ
Community Manager
Community Manager