Sumifs cross sheet



I am trying to pull in project expenses from an expense tracking sheet, based on multiple criteria.

  1. I want to match the project row in my consolidation sheet with the expense sheet (to determine row being calculated)
  2. I then want to only look at expense lines that are "Completed" (no more expenses are expected on the line)
  3. Then sum all the rows that meet those criteria

I tried the sumifs formula and I am getting an error. I made a video to show what I did

And heres the formula I used

=SUMIFS({Project Name}, [Primary Column]@row, {Project Expense Tracking Expense status Completed}, "Completed", {Project Expense Tracking budget actual spend})

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!