Order of the accounts keep changing in the Balances tab

Spreadsheets Google Sheets
1

The cell that my account balances show up in the Balance tab keep changing their order. I have that ‘balance’ cell linked to another spreadsheet (via “= point to cell” formula) to keep track of my upcoming payments, and I have to update the cell almost every time. It now points to the cell below or above it. Very frustrating.

Is there a way to make those cells in the Balance tab to be stationary; or conversely, a formula that will always point to my “Main Checking” balance, rather than just the cell of the Main Checking?

2

Do you have the Accounts tab filled out?

3

Yes I do, and they’re in groups.

4

Check out this post to change the Balances sheet sort order:

5

Great, thank you! I will do that.

6

THANK YOU! Changed it without problem, now should work great.

7

If you want to keep them ordered by balance or anything else, you can dynamically choose the correct cell with some formulas I posted here.

8

this is nice. I reference some of the balance cells directly and haven’t run into them moving around but I’m glad to know there are solutions for that

9

Glad this helped @kssjd5 . Thanks everyone!

10

I’ve had this exact problem, and this solves it for me. Thank you!