report unselected options in form

R Gardiner

Hello,

For ease of form use (and keeping a positive tone), I've created some drop down menu where users can select "all that are true" from a variety of options. It would be useful for those of us viewing the submitted forms to be able to easily see which options were not selected- as those highlight gaps in service.

Currently the column result in the sheet will list all of the selected items from the form in a single box- but does not give any indication if any items were not selected.

The only way I can find to do this right now is very convoluted and clunky involving work flows with lots of conditions. It would be wonderful to have an option to select "if any of these items are unselected- populate unselected items in designated cell".

thank you!

Paul Newcome

If you make a list (in another sheet is fine) of all of the possible options, this can serve two purposes.

First, in Table View, it manages the column properties and syncs them with the options you have listed in this other table. There are a number of ways this could be helpful.

Second, we can use a formulas with {Cross Sheet References} to output which options were not selected.

=JOIN(COLLECT({Reference Sheet Selections Column}, {Reference Sheet Selections Column}, NOT(HAS([Selected Options]@row, @cell ))), CHAR(10))

Here it is working all in the same sheet. The first column [All Possible Selections] would be your reference table and [Selected Options] would be the column from your form.

Putting the formula into a multi-select dropdown column and wrapping text should give you the cleanest results.