Please help me show/hide a Column Based on Value of Another column use "Show?" (show if)

[buinam]

I have 2 column:

Column1 “name” (Type: “text”). Values in value in each row google sheet is: A, B, C, D, E, F, G, H

Column2 “checkbox”(Type: Yes/no)

I want column 2 (“checkbox”) to only show when the value of column 1 is “A”, “C”, “E”…

or can i change column 1 type to enum or enumlist?

Thanks

[Aurelien]

Hi @buinam

Colunm1 :

Use the black pen attached to the column and set type EnumList and add values A, B, C, D, etc.

Column2:

Use the black pen attached to the column and use this:

ISNOTBLANK(
  INTERSECT(
    LIST("A","C","E" ),
    [column1]
  )
)

Here is the result: