How can I make show or hide column with list based on conditions , exemple:
if I choose
[Seller]= B then show column [index] with list 1.5,1.6
OR
[Seller]= A then show column [index] with list 1.5,1.56,1.61,1.67,1.74
OR
[Seller]= C then show column [index] with list 1.5,1.6,1.7,1.8,1.9
Hello, please put this in your Suggested Values or Valid If
IFS(
[Seller] = “A”,
LIST(
“1.5”,
“1.56”,
“1.61”....
),
[Seller] = “B”,
LIST(
“1.5”,
“1.6”
)...
)
thank you sir for responding me it works nice , what if I want to show it like “look at pic” instead of dropdown list
I tried datatype “ENUM” but gives error
Please check this article how you can create a dynamic dependent dropdown…
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |