Sum If & contains


Hi, Hoping for some help with a Sum IF formula. I would like to sum if from 'Sheet 2' Value based on Sheet 1 project code. I have tried the below formula utilising 'Contains' however it is returning 0 rather than sum of project 304.

Sheet 1

Sheet 2

Any assistance would be appreciated



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!