Hide a value from ref if it has been choose on another column

[Yogi_Hayate]

Hi,

Currently i making an app for stock cutting material. And, I got jam at this process.
I'd like to hide values which had been choose in another row.  

I have two sheets which is
 (-) Database Stock Cutting 
 (-) Cutting Process

In [Cutting Process] i have multiple row
[Bhn_Ptg_Struk] = Ref ID from (Stock Cutting) sheets   ---> As Raw Material
[Uk_Ptg_1]  = Ref ID from (Stock Cutting) sheets -----> As Final Cut Stock 1
[Uk_Ptg_2] =  Ref ID from (Stock Cutting) sheets -----> As Final Cut Stock 2
[Uk_Ptg_3] =  Ref ID from (Stock Cutting) sheets -----> As Final Cut Stock 3

For instance : (There are 4 difference size [A,B,C,D])
Raw Material --> I choose A as values [Bhn_Ptg_Struk]

After, A picked out, Ref Enum only show [B,C,D] as a list for size 1, 2,3  

Size 1  : (Option for this row = B, C, D)
Size 2 : (Option for this row = B, C, D)
Size 3 : (Option for this row = B, C, D)

Then, Let's say i choose D as values [Uk_Ptg_1],
Size 2 & Size 3 only have B, and D as dropdown option as a results, and so on..
Size 2 : (Option for this row = B, C)
Size 3 : (Option for this row = B, C)

I tried to insert a formula in [Uk_Ptg_1] Valid if in this way

FILTER("Database Stock Cutting",
([_THIS] = [ID_Ukuran Potong])
)
- LIST([_THISROW].[BHN_Ptg_Struk]) 

But, in the end, all of my values based on references didn't show up in [Uk_Ptg_1].
Any ideas to fix this?

[Joseph_Seddik · Accepted solution]

• [Bhn_Ptg_Struk] : [sizes] - LIST([Uk_Ptg_1], [Uk_Ptg_2], [Uk_Ptg_3])
• [Uk_Ptg_1] : [sizes] - LIST([Bhn_Ptg_Struk], [Uk_Ptg_2], [Uk_Ptg_3])
• [Uk_Ptg_2] : [sizes] - LIST([Bhn_Ptg_Struk], [Uk_Ptg_1], [Uk_Ptg_3])
• [Uk_Ptg_3] : [sizes] - LIST([Bhn_Ptg_Struk], [Uk_Ptg_1], [Uk_Ptg_2])

[Yogi_Hayate]

Ahh i get it!

Thanks to you @Joseph_Seddik , I manage to solve the problem.