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 at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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 at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
This is exactly what I needed! Thank you so much!!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives