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 | |
18 | |
17 |