When Exporting to Excel Order set Order Rows

renealvarez

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

Genevieve P.

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

Genevieve P.

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

renealvarez

This is exactly what I needed! Thank you so much!!