How to set up a Budget Chart.

I have a

  1. sheet set up with a form on it for inputting invoices and costs to a budget with a form used for inputting the data,
  2. a sheet that has the budget set up with each category to show what has been budgeted.

What I am looking for is some helpful info on how to set up a dashboard showing a chart with each budget item showing what the budget is for that category as well as what has been spent to date on that category. Seems simple enough but it is driving me nuts trying to figure it out. Thanks for any assistance.

ZC

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!