MultiSelect: Export to Excel Not Useful
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
Comments
-
This is a great idea. The reason this happens is because the data is stored in Smartsheet as a single text string. If you have not already, I suggest filling out a Product Enhancement Request.
-
Hi Purnima,
thanks for the feedback.
If you expand the cell in Excel, you should find the values are line delimited.
I will request the help article to be updated and double check that the expected functionality is working as intended.
Thank you,
Kara
-
Good to know. Using a FIND function for CHAR(10) does produce results. Thanks, Kara!
-
Hi Kara,
I can see the data delimited when I expand, but I'm trying to separate each value into a separate column and I don't see how to make that work. Any ideas?
Thank you!
Nadja
-
Are you trying to parse it in Smartsheet or Excel?
The delimiter is a line break CHAR(10). You would need to leverage this to parse it out.
-
I was trying to do it in Excel. Should I use the the CHAR(10) function in Smartsheet?
-
The CHAR(10) delimiter pulls through to Excel, but I am not sure how to use it to parse data differently than you would in Smartsheet.
-
Re-opening this. I tried to export to Excel with the dropdpwn list option, multi-select, and the Excel export is combining the answers to a single word, no CHAR(10). Exporting to Google sheets does include the CHAR(10).
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives