How to Add Categories in Personal Budget Management Template
Hello. I am newish to SmartSheet. I am wondering if anyone can help me understand how to add more budget categories to the existing Personal Budget Management project template (specifically trying to add categories to the "Budget Setup" sheet in a way that keeps the formulas in tact... currently only a certain number of categories are setup for plug and play, and I need more). Thank you!
Best Answer

Hi @jakeloy1
Template Sets tend to have instructions embedded in the set, usually in the form of Column Descriptions. In your case, if you hover over the "i" on the Category column of the Intake sheet, it should tell you what to do! 🙂
To update the dropdown values, double click on the column title "Category" and change the values in the square box:
To update the metric sheet, go to the Budget Set Up sheet and change out the highlighted yellow values to match your current values:
If you have more than 10, no problem!
Create a new row below the "Budget Category 10" row and make sure it was automatically indented it so it's under the parent "Categories". You can test to see if it's correctly indented by clicking the  next to the word "Categories" and ensure it collapses with the other rows.
Then create a new row to match under the "Percent Allocation (%)" parent section, linking in the value by using a simple = sign and clicking on your new Category name:
You'll notice that the other formulas above this cell have a $ sign in front of the reference, which is best practice when you want to ensure it stays "stuck" on that column. (See: Create a cell or column reference in a formula)
Use DragFill to drag down the formula that shows the % in the Value column:
You'll need to do the same thing for every section that has Categories listed: add a new row, bring in the Category Value from the top section of the sheet, dragfill formulas where they appear. You'll need to use a bit of detective work to figure out which of the formulas you can simply drag, and which ones you may need to replicate by finding the cells that the other formulas are referencing and building yours out to be similar.
EXAMPLES:
For the Budget section, you can dragfill the entire formula section down:
And it will update to reference the correct cells.
But the Expenses section references rows below it that won't exist until you add in your new category. Double clicking on a formula will highlight the cells it is referencing so you can recreate what it's doing by referencing your newly created rows.
Does that make sense? If you get stuck with a particular formula let us know!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Answers

Hi @jakeloy1
Template Sets tend to have instructions embedded in the set, usually in the form of Column Descriptions. In your case, if you hover over the "i" on the Category column of the Intake sheet, it should tell you what to do! 🙂
To update the dropdown values, double click on the column title "Category" and change the values in the square box:
To update the metric sheet, go to the Budget Set Up sheet and change out the highlighted yellow values to match your current values:
If you have more than 10, no problem!
Create a new row below the "Budget Category 10" row and make sure it was automatically indented it so it's under the parent "Categories". You can test to see if it's correctly indented by clicking the  next to the word "Categories" and ensure it collapses with the other rows.
Then create a new row to match under the "Percent Allocation (%)" parent section, linking in the value by using a simple = sign and clicking on your new Category name:
You'll notice that the other formulas above this cell have a $ sign in front of the reference, which is best practice when you want to ensure it stays "stuck" on that column. (See: Create a cell or column reference in a formula)
Use DragFill to drag down the formula that shows the % in the Value column:
You'll need to do the same thing for every section that has Categories listed: add a new row, bring in the Category Value from the top section of the sheet, dragfill formulas where they appear. You'll need to use a bit of detective work to figure out which of the formulas you can simply drag, and which ones you may need to replicate by finding the cells that the other formulas are referencing and building yours out to be similar.
EXAMPLES:
For the Budget section, you can dragfill the entire formula section down:
And it will update to reference the correct cells.
But the Expenses section references rows below it that won't exist until you add in your new category. Double clicking on a formula will highlight the cells it is referencing so you can recreate what it's doing by referencing your newly created rows.
Does that make sense? If you get stuck with a particular formula let us know!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
Holy cow! I don't think I've ever received such comprehensive service in my life. Thank you so much for your help. I've updated the sheet accordingly and everything is working! THANK YOU!

Haha! Glad I could help!
Please do followup if any of the formulas look off and we can work on them together  that's what the Community is here for. 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!