Problem with text format in smartshet exports into excel
Hello,
I have an issue when I export my smartsheet sheet into Excel using Data Shuttle.
The excel that is generated has all the columns as text type , even the ones that only have numbers on it and I will like to know in which way I could have the columns with only text in smarsheet sheet as text format in the generated excel.
I saw that the excel export is regenerated every time so I can't create a template and set in there the desired format (or I don't know how to do it).
thanks you very much in advance for your help,
Roser
Answers
-
Hi @Roser
At this time there isn't a way to pre-set the column type in Excel that the data will be exported as using Data Shuttle. Since a new file is created each time, you'll need to adjust the column type in the Excel document after the export has occurred. Please let the Product team know about your use-case and request by filling out this form, here!
Thanks,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
This content has been removed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives