Export to Excel Issues
We are having issues when exporting our Smartsheet pages to Excel. In most of the cases where the column is defined as a "Text/Number" column, if there is not text WITH number (only numbers), it comes out scrambled in Excel (Below is the original taken from Smartsheet)
And below is how it exports to Excel (see top right hand side):
Can anyone offer any explanation as to why this is happening?
I should mention that in some cases the claim# field will be filled with text and numbers, and sometimes it is only numbers. There is no way to for us to restrict this column to one or the other. Has anyone found a way around this other to always include text with the numbers?