How to Show a more than one Column with Enum

JonasGndr · 12-01-2021 01:49 AM

Hello,

I have a question about displaying columns based on enums.

I want to be able to select a value and then display one or more columns.

I already tried it with [column_name]=“Value”, but it only works if an expression is entered and I want that if I enter a certain value several columns are displayed.

For example:
[number]=“3” => 3 columns are displayed
[Number]=“2” => 2 columns
[Number]=“1” => 1 column

Is this possible and understandable what I mean?

Thanks a lot

Suvrutt_Gurjar

It is not exactly clear what you are aiming for, but maybe you wish to take a look at column constraints to start with.

JonasGndr

Thank you for your quick reply.

So basically I have multiple workstations where monitors need to be inventoried. And I want to make a selection of how many monitors are at the workstation and based on that selection, columns should be displayed.

E.G.

I select:
1 monitor => The columns Monitor1 are displayed.
2 monitors => The columns Monitor1 and Monitor2 are displayed.
and so on

Suvrutt_Gurjar

Please take a look at the following article

JonasGndr

That seems to look what Im aiming for but I dont work with Google Forms, I have my Data in an Excel sheet and just want to know if there is any command that I can use

Suvrutt_Gurjar

It need not be in Google forms.

Please take a look at the following section in the article

Conditional branching in your spreadsheet and the Editor

JonasGndr

Okay I read it and I already did that but with this solution I can only show one Column at time.

Im looking for an expression like: [collumn_name]=“1” OR [collumn_name]=“2” OR … but this also doesn’t work

JonasGndr

Okay I have tried something around and found out how it works. Thanks for the help