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
-
You would need to use something along the lines of...
=SUMIFS({Sheet 2 Amounts Column}, {Sheet 2 Cost Code Column}, [Sheet 1 Cost Code Column]@row)
-
=SUMIFS({Invoice Log Range 2}, {Invoice Log Range 1}, [Cost Code]@row)
Use this one and see if it works.
Answers
-
You would need to use something along the lines of...
=SUMIFS({Sheet 2 Amounts Column}, {Sheet 2 Cost Code Column}, [Sheet 1 Cost Code Column]@row)
-
Thanks for the rely,
For Whatever reason that is not working. I've tried a few things differently but nothings getting it.
-
When you say "not working" do you mean it is throwing an error or providing an incorrect result? What is the error (if any) and what is the actual result vs the expected result if there is no error?
-
#UNPARSEABLE is the error.
-
Can you copy/paste the formula you are using directly from your sheet to here?
-
=SUMIFS({Invoice Log Range 2}, {Invoice Log Range 1}, {Invoice Log Range 2}@row)
-
=SUMIFS({Invoice Log Range 2}, {Invoice Log Range 1}, [Cost Code]1:[Cost Code]25@row)
-
Sorry, the second formula is the one that I am using
-
=SUMIFS({Invoice Log Range 2}, {Invoice Log Range 1}, [Cost Code]@row)
Use this one and see if it works.
-
Yes! It Worked! Thank you so much for your patients!
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!
