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?

Double

Single

When exporting to Excel it outputs to

DoubleSingle

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

Purnima Gore

Cierr Limited

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

https://www.cierr.com

Comments