I’m attempting to use the Savings & Debt Worksheet. The manual liability account i have created is not showing up in the drop down. This account IS showing up in the Debt Planner worksheet. I have reviewed this blog: Accounts Not Showing in Debt Planner Dropdowns I have reviewed this blog as wel…

You can see that the dropdowns in column L are fed from ='Savings & Debt'!$AI$7:$AI. If I unhide the hidden area to the right of the template, I see this formula in AI6 filling that range: ={{"Account","Period Budget"};sort(iferror(filter({INDIRECT($AW$26&"!"&$AX$27&"2:"&$AX$27),OFFSET(Categories!…

You’re saying that the account isn’t showing up in column L of the Savings & Debt template, @dmitriy.sidelnik ?

Randy, that was exactly the issue. You are a true expert. Thank you for your help.

One more quick question Randy. I notice that my BALANCE does not auto populate. What could be the cause of that ?

(column O in Debt Payoff Goals)

Savings & Debt - Tracked Debt Account drop down issue

Spreadsheets Google Sheets

Topic		Replies	Views
Accounts Not Showing in Debt Planner Dropdowns Google Sheets tcs-debt	14	1735	April 7, 2021
Manual account missing in the dropdown on the Debt Planner sheet Google Sheets debt	6	793	October 21, 2021
Debt planner not showing all accounts Google Sheets	1	204	August 3, 2023
Debt Payoff Planner - no accounts in dropdown Google Sheets how-to	5	198	July 11, 2024
Savings & Debt Sheet: "Input must fall within specified range" Google Sheets tcs-savings	2	968	March 24, 2021

Savings & Debt - Tracked Debt Account drop down issue

Related topics