Benches Uncategorized

3

Need help with formulas for a Personal Bu…

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I am using the Personal Budget template in the Numbers App and I changed the categories, but I must have done something wrong. I used the pop-up menu under the Cell tab on the Transactions page. On the Budget page, when I changed them, they showed up under the "donut" chart, so everything looked like it was working, but now they don't sync between the Transactions page and the Budget page. When I enter a transaction, it does not change anything on the Budget page. Is there somewhere with step by step instructions on the formulas, etc?

Any help is greatly appreciated.

3 replies

Sign in or join Beachball Help to reply.

  1. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Make sure the spelling is exactly the same here:

    As it is in the Pop-Up Menu cells in column C of Transactions.

    You can set up the Pop-Up Menu in one cell with your new categories. Then command-c to copy it, select the whole column, command-v to paste. Then set each cell to the category you want.

    SG

  2. 0

    lnustrakarnats

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thank you for your reply. They are an exact match on both pages, though. No extra space at the end, even capitalized the same. So, I don't know what to do.

  3. 0

    jaxjason

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    can you show us the formula on the budgets page, probably have a SUMIF in it.

    Jason