sort rows by revision date

Tim McCarthy

Can a sheet's rows be sorted according to date of revision? Sorting this way would allow a quick view of the latest revisions that have been made to the sheet.

Zac

Yes you have the option to add a few different system columns to a sheet, modified date being one of them. Add the modified date column and then sort descending and the most recently modified rows should be on the top of your sheet.

Jeff K.

I prefer to keep the sheet as is (no sorting), but use Filter on the the modified date column...This way you won't screw up the layout later on when you exit the sheet/save

Zac

I agree with Jeff. Sorting has a tendency to do more harm than good on sheets. It will mess up your layout and it's very cumbersome to try to get it back to the way it was. Another option for you Tim might be the Highlight Changes feature. It will highlight any cells modified based on the criteria you choose and is simple to turn on and off.

Tim McCarthy

Thanks Zac and Jeff. I agree about the sorting of sheets. Now, I am thinking that I could perform the sort in a report.

rach

"Sorting has a tendency to do more harm than good in sheets"

Wish there was some warning about sorting rows (apart from the help community!) ! I've made a mess of a project by viewing in alphabetical order. Well, I thought I was viewing, now turns out I was 'sorting', with no way to go back. 

The only clue I've garnered that might help me fix this is a mention somewhere that I can sort the 'automatic number' column? Does anyone know how to do this?

This won't fix it 100%, as some rows have been inserted in the middle of sheet at different times etc, but will help somewhat. 

 

J. Craig Williams

To turn on auto-numbering, add a new column and set the type to "Auto-Number System" and then "Auto-Number"

You've already pointed out some of the limitations to them. The full article is here:

https://help.smartsheet.com/articles/1108408-auto-numbering-rows

Craig