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?