SumIfs or Contains or Both forumlas

I am trying to update this smartsheet (1st pic) "Spent Amount" to match another sheet. That means that if Branch 2 is the same Branch name as the 1st smartsheet, then the amount in the "Amount" column, it will update the 1st Smartsheet "Spent" column

This is the formula I am using:

=SUMIFS({Branch Name}, {Spent amount}, [BC Budgeted Amounts by Region - 2022]@row)

But it's returning $0 instead it should return $225.75

Any assistance would be appreaciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!