Multiplying column values?

Hi Community,

I have a sheet with section score values ("Ease Score", "Permanence Score", "Impact Score", "Cost Score") that I am trying to multiply to find an overall score ("Project Score"). Each section score column has a column formula with nested IFs to return the correct value, and I'm worried that's what is causing my "Project Score" value to return #INVALID OPERATION. Is it that? Something more simple? What am I missing?!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!