Hi Jeffrey,

You cannot sort if you have filters applied to your sheet. Do you have a filter applied? Try this, right click on a column header and select Remove All Filters, then try and sort your sheet.

Let me know if you are still having trouble sorting!

I agree with 100% with Peter Bryn. SmartSheets: please add this to your upgrade list.

Hi All—

I realize that this is an older thread, but I wanted to mention that we now have a new way to filter sheets.

Although you still can't sort AFTER applying a filter (we've got your votes for that down on our enhancement request list), you can save a filter, then disable to sort and enable the saved filter. Details on this are available in our Help Center: https://help.smartsheet.com/articles/504659-using-filters-to-show-or-hide-sheet-data

One caveat to sorting in a sheet is that if you save, the sort is permanently applied and can't be undone. If you're looking for a way to safely sort sheet content without the risk of permanently changing the structure of the sheet, create a report: https://help.smartsheet.com/articles/522214-creating-reports

Thanks Peter, I've passed your feedback for a continuous sort along to our Product team as well.

Hi James, I'll get your vote down for Editors to have the ability to sort locked rows.

Hi John,

It's possible that you're selecting child rows across different hierarchies, or you're trying to sort locked columns (not sure if you mean't that the columns were "unlocked" versus "unfrozen"). 

Hierarchies: You'll need to select from parent row to parent row, as opposed to selecting a child in one hierarchy and a child in a different hierarchy.

If the above isn't the case for you, contact our Support team (support@smartsheet.com) so they can troubleshoot further.

James, I agree, not being able to sort when some there are locks doesn't appear to serve a purpose.

Can anyone clarify the reason?

Roland