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

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

0 1 75
1 REPLY 1

Aurelien
Google Developer Expert
Google Developer Expert

Hi @buinam 

Colunm1 :

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

 

Aurelien_1-1733814243715.png

Aurelien_2-1733814268394.png

 

Column2:

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

Aurelien_3-1733814324736.png

Aurelien_5-1733814438856.png

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

Here is the result:

Aurelien_6-1733814581882.pngAurelien_7-1733814606713.png

 

 

Top Labels in this Space