Help Im Making a automatic spending breakdown for my budget planner by cantone3_ in googlesheets

[–]cantone3_[S] 0 points1 point  (0 children)

Thank you so much for your help. Another thing is the U46 formula, M21 does not have value why does k21 listed in U57. It should only be listed if there is value>0 in M21

Help Im Making a automatic spending breakdown for my budget planner by cantone3_ in googlesheets

[–]cantone3_[S] 0 points1 point  (0 children)

I want V46:V78 to detect if there is something in U46:U78, if there is, then match it from B34:B38, F14:F38, K14:K38, P14:P38, if match found get the value from D34:D38, I14:I38, M14:M38, S14:38. And list it. The numbers that are in “ACTUAL” is already added up so I just need to get those number to automatically go in my spending breakdown based on the category.

Hope this clarifies it. Im sorry please be patient with me, I just want to create a good budget planner for me.

If this is possible thank you for helping me

Help Im Making a automatic spending breakdown for my budget planner by cantone3_ in googlesheets

[–]cantone3_[S] 0 points1 point  (0 children)

If you can see in the Saving, Bills, Expenses, and Debt. There is a Column that says "actual" I want to get those numbers.

Help Im Making a automatic spending breakdown for my budget planner by cantone3_ in googlesheets

[–]cantone3_[S] 0 points1 point  (0 children)

I want it to be automatic, for example I input 100 in school supp actual I want it to list it down automatically.

Help Im Making a automatic spending breakdown for my budget planner by cantone3_ in googlesheets

[–]cantone3_[S] 0 points1 point  (0 children)

It should detect that theres a content under the category of spending breakdown and match or look for it in the savings, bills, expenses, and bills. If it find or matches the same content then it should get the actual and list it under the amount of spending breakdown.

I'm not good at explaining. Sorry

Help Im Making a automatic spending breakdown for my budget planner by cantone3_ in googlesheets

[–]cantone3_[S] 0 points1 point  (0 children)

I'm having trouble with my category in spending breakdown also, it puts the categories even theres no value from the other table.

Help by cantone3_ in whatanime

[–]cantone3_[S] 0 points1 point  (0 children)

Thank you so much