I have a survey with 50 questions, all of them have as possible answers โit worksโ or โit does not workโ,
I would like to know if there is any formula or method of filtering only the results โdoes not workโ, in a real or virtual column.
Thanks
I would recommend establishing a table with 3 columns = ID(key), Question(Text), It Works?(Yes/No)
Then list each of the 50 questions as a row in the table. You can then use an editable table to display the questions allowing the user to go through the list checking those that work. You can still customize the Yes/No column so that โIt Worksโ marks the column TRUE and โIt Does Not Workโ as FALSE.
With it built this way you can then easily create an expression to filter the rows where the It Works column = FALSE
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |