Budget v. Invoice Cost Codes


I have two Smartsheets. Sheet 1 is my budget broken down into various cost codes. Sheet 2 is a log of all my invoices with cost codes and amounts assigned to each invoice. I am trying to take the amount from each invoice and have them populate in my budget according to their cost codes. The budget amounts for each cost code need to be the total sum of the invoices that the cost code is assigned to.

In the end I will be able to input invoices and the budget will be updated with the total sums for each cost code.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!