As I explore the Foundation sheet I notice I can sort rows in some tabs but now others. In the Other tabs sorting will break the formulas.
Also, I need guidance regarding where to place the cursor. Sometime it sorts with the cursor on the header row and sometimes the cursor must be in a lower row.
Table
Transactions Sort ok cursor below the header
AutoCat Do not sort sort will breaks the sheet,
Categories Sort OK Cursor below header row
@Russellreno Your references seem correct. When sorting data, I usually highlight the area that I would like to sort (including the headers).
When you do re-sort on the categories tab, make sure there aren’t any blank rows between the categories as these can break the data validation on the Transactions sheet that allows you to choose a category from the dropdown.
Below is an article on Filtering and Sorting data in Google Sheets. Hope this helps
I find if I sort the Accounts sheet it breaks the Balances tab as well.
Hi @RobA1701,
The accounts sheet should NOT be sorted. You can make overrides in the green background cells, but sorting that sheet will cause other sheets to break.
Jon
So I discovered. It would be great if the FAQs listed the sheets that can be sorted without problems. Categories seems okay. Thanks.
so if I sorted that tab, is it recoverable? I have no idea how to go back to where I was (undo is not available now)
Can you go back and get the version before you sorted? Click on the little watch-like icon on the top right hand side to see the previous versions available.
I find this very handy when I get ‘creative’ with my sheet.
Thanks so much! I am back to working again - I lost a few changes - but those are recoverable (I finally had my net worth correct, but know what I need to do to make those changes again).
You have made my day, thanks!
Glad to hear it is working @lewhitman, and thanks for the solve, @susandennis. 