MultiSelect: Export to Excel Not Useful

Purnima Gore
Purnima Gore ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I have just tested the MultiSelect Function.  When you export to Excel it simply concatenates the items to make a single word


For example

What type (s) of room could we book you into?



When exporting to Excel it outputs to


That is no help, unless there is a delimiter in the cell, it is worthless in an output.

I cannot find any articles to tell me how to change this.  the only other option is to put a comma at the end of each option within the choice which is a workaround that should be fixed.

Is this a bug?

Kind regards


Purnima Gore

Cierr Limited

Your Time is Important, you want to Stay on Track, We can help you use the Right Tools