Sum Function Error

I created a resource planning sheet to track each employee's workload. I have Workload Rating automatically changed to 3, 2, or 1 based on the Engagement Level. Lead = 3, Core = 2, and Ad Hoc = 1. I also have a Total Rating to sum up the Workload Rating. However, it returns a 0, for example, for Employee 1, the Total Rating should be 6. Workload Rating column have multiple IF functions, so I'm thinking that might throw the sum off for some reason. Any help would be appreciated. Thanks.

Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!