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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives