SumIfs or Contains or Both forumlas

Roshni Verappan

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.

thanks

Roshni Verappan

Thank you very much @Mike TV I knew it was something silly and small...

Appreciate the quick response.

Mike TV

@Roshni Verappan

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

Roshni Verappan

Thank you very much @Mike TV I knew it was something silly and small...

Appreciate the quick response.