Cross-sheet formula for conditional sum of column

I am trying to create a formula that calculates that sum of a column from a different sheet. Conditions are that the column for PM name of the referenced sheet must match the PM name for this row. (trying to calculate this sum for multiple PM names)

The column I am attempting to sum from the referenced sheet contains a conditional formula that assigns 0, 1, or 2 depending on a specific task verbiage and the column status is "active".

I keep getting a sum of 0, but unsure why.

Can anyone help??


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!