How to sort Monthly budget sheet by budgeted amount

Spreadsheets Google Sheets
2

I believe you are referring to this other post.

Modifying what was suggested there, how about this for sorting by budget amount?

Monthly Budget sheet, cell Q16 :

={query(
   {INDIRECT(K21),INDIRECT(K20),INDIRECT(K19),INDIRECT(K22),ARRAYFORMULA(XLOOKUP(INDIRECT(K19),Z16:Z,AA16:AA,0,0,1))},
   "select Col1, Col2, Col3 where Col1 = 'Income' and Col4 <> 'Hide' order by Col2 asc, Col5 desc, Col3 asc",0);
  query(
   {INDIRECT(K21),INDIRECT(K20),INDIRECT(K19),INDIRECT(K22),ARRAYFORMULA(XLOOKUP(INDIRECT(K19),Z16:Z,AA16:AA,0,0,1))},
   "select Col1, Col2, Col3 where Col1 = 'Expense' and Col4 <> 'Hide' order by Col2 asc, Col5 desc, Col3 asc",0)}
2 Likes