Show if column list based on conditions

Soufiane_M · 12-26-2020 10:38 PM

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

JuneCorpuz

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”
     )...
)

Soufiane_M

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

Aleksi

Please check this article how you can create a dynamic dependent dropdown…