Export to Excel so multi-select field is comma seperated
I want to use Smartsheet to hold our eCommerce database so I can control field "answers" and make everything consistent using mulit-select (restricted answers).
The problem I have is when I export to Excel the field in not comma separated anymore which means our system isn't populating fields correctly. It is either entering the data without commas like the screen below, or just ignoring what is in the field all together and not updating.
I have many columns I need to be comma separated when exported so I am hoping there is a very easy fix for this. If not, I will be forced to figure this out in an excel sheet that does not have as many controls.