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
It is not exactly clear what you are aiming for, but maybe you wish to take a look at column constraints to start with.
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
Please take a look at the following article
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
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
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
Okay I have tried something around and found out how it works. Thanks for the help
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |