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
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:
User | Count |
---|---|
18 | |
11 | |
7 | |
3 | |
2 |