When Exporting to Excel Order set Order Rows
Hi!
Is it possible to set the order of the columns that are exported? I am able to export my smartsheet and apply a filter that will hide the rows that I need hidden but it is ordered based on when the row was created. Can that be changed to be ordered by one of the column headers instead? If so, how do I do it?
Thanks!
Rene
Best Answer
-
Hi @renealvarez
Exporting the sheet to Excel will keep the row order that's set in your Smartsheet Sheet. This means that if you need a different order, you can Sort the rows in Smartsheet based off of that column. When the sheet in Smartsheet is in the correct order, then your exported file will have that correct order as well!
See: Sort Rows to Organize Your Data and Export a sheet or report
If you don't want to reorganize your original sheet in Smartsheet, you could create a Report that has the correct sort order applied and then export from the Report instead (you could also apply a filter this way as well). See: Build a row report
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
Hi @renealvarez
Exporting the sheet to Excel will keep the row order that's set in your Smartsheet Sheet. This means that if you need a different order, you can Sort the rows in Smartsheet based off of that column. When the sheet in Smartsheet is in the correct order, then your exported file will have that correct order as well!
See: Sort Rows to Organize Your Data and Export a sheet or report
If you don't want to reorganize your original sheet in Smartsheet, you could create a Report that has the correct sort order applied and then export from the Report instead (you could also apply a filter this way as well). See: Build a row report
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
This is exactly what I needed! Thank you so much!!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives