Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
SUMIFS Cross Sheet Issue
I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What I am trying to accomplish is a sum for Sheet-2 based on multiple criteria from Sheet-1:
Criteria from Sheet-1
- Job ID
- Cost Code ID
Sum Range: Act. Expenses
Basically I want to add all the specified cost codes from a specific job ID and when I create the formula the return value on Sheet-2 for the Row: Engineering, Column: Act. Expenses is 0.
Let me know what you all think, I was wondering if blank cells would affect the process but I am not sure.