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

Try removing the quotes from around each of the numbers to be output. The quotes will output a text value which can't be multiplied by anything.
Answers

Can you provide the nested IF?

Sure. For "Impact Score" the nested IF is:
=IF(([Anticipated annual savings]@row) = "25K or Less", "1", IF(([Anticipated annual savings]@row) = "50K", "2", IF(([Anticipated annual savings]@row) = "75K", "3", IF(([Anticipated annual savings]@row) = "100K", "4", IF(([Anticipated annual savings]@row) = "200K", "5", IF(([Anticipated annual savings]@row) = "400K", "6", IF(([Anticipated annual savings]@row) = "500K", "7", IF(([Anticipated annual savings]@row) = "600K", "8", IF(([Anticipated annual savings]@row) = "750K", "9", IF(([Anticipated annual savings]@row) = "1M", "10"))))))))))

Try removing the quotes from around each of the numbers to be output. The quotes will output a text value which can't be multiplied by anything.

PAUL! YES! Thank you! This did the trick.

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!