Budget v. Invoice Cost Codes

Stowe Olesen

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.

Paul Newcome

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)

Paul Newcome

=SUMIFS({Invoice Log Range 2}, {Invoice Log Range 1}, [Cost Code]@row)

Use this one and see if it works.

Paul Newcome

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)

Stowe Olesen

Thanks for the rely,

For Whatever reason that is not working. I've tried a few things differently but nothings getting it.

Paul Newcome

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?

Stowe Olesen

#UNPARSEABLE is the error.

Paul Newcome

Can you copy/paste the formula you are using directly from your sheet to here?

Stowe Olesen

=SUMIFS({Invoice Log Range 2}, {Invoice Log Range 1}, {Invoice Log Range 2}@row)

Stowe Olesen

=SUMIFS({Invoice Log Range 2}, {Invoice Log Range 1}, [Cost Code]1:[Cost Code]25@row)

Stowe Olesen

Sorry, the second formula is the one that I am using

Paul Newcome

=SUMIFS({Invoice Log Range 2}, {Invoice Log Range 1}, [Cost Code]@row)

Use this one and see if it works.

Stowe Olesen

Yes! It Worked! Thank you so much for your patients!

Paul Newcome

Happy to help. 👍️