Hello,
I got an issue with a dependent dropdown list, for some reason it doesn't work.. If already created multiple successful dependent dropdown lists but for some reason this one won't work..
Is there some thing like text that blocks it?
Here what I got
File if prefered: Google Drive
I got an issue with a dependent dropdown list, for some reason it doesn't work.. If already created multiple successful dependent dropdown lists but for some reason this one won't work..
Is there some thing like text that blocks it?
Here what I got
copy.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
3 | Parameters : ACS-038 | ||||
4 | Type activiteiten: | Feed/Food | |||
5 | Aantal Feed/Food activiteit: | ||||
6 | |||||
7 | |||||
8 | |||||
9 | |||||
10 | |||||
11 | |||||
12 | |||||
13 | |||||
14 | |||||
15 | |||||
16 | |||||
17 | |||||
18 | |||||
19 | Dropdown list: Type activiteiten | Placeholders | |||
20 | Feed/Food | Aantal Feed/Food activiteit: | |||
21 | Feed/Food & Landbouwproducten | Aantal Feed/Food & Landbouw activiteit: | |||
22 | Landbouwproducten | Aantal Landbouw activiteit: | |||
23 | |||||
24 | |||||
25 | |||||
26 | |||||
27 | |||||
28 | Feed/Food | Feed/Food & Landbouwproducten | Landbouwproducten | ||
29 | <2 | <2 | 1 Landbouw activiteit | ||
30 | 2< - <5 | 2< - <5 | 2 Landbouw activiteit | ||
31 | 5< - <10 | 5< - <10 | 3 Landbouw activiteit | ||
32 | >10 | >10 | Activiteit mengen in bulk | ||
33 | Feed/Food + 1 Landbouw activiteit | Invoer van organische meststoffen en/of groeimedia | |||
34 | Feed/Food + 2 Landbouw activiteit | ||||
35 | Feed/Food + 3 Landbouw activiteit | ||||
36 | Activiteit mengen in bulk | ||||
37 | Invoer van organische meststoffen en/of groeimedia | ||||
ACS-038 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A5 | A5 | =IF(B4="Feed/Food",'ACS-038'!$B$20,IF(B4="Feed/Food & Landbouwproducten",'ACS-038'!$B$21,IF(B4="Landbouwproducten",'ACS-038'!$B$22,"N/A"))) |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
B4 | List | =TypeActACS038 |
B5 | List | =INDIRECT(B4) |
File if prefered: Google Drive