Help w/adding up formula totals
Hi team  I created a test sheet that I'm experimenting with various drop down menus creating scores. The drop down to score is working fine, where I have a problem is getting the "Total score" column to add all 5 scores.
What am I missing?
Total score formula:
=VALUE([Impact score]@row + VALUE([SLO score]@row + VALUE([Short term resilency score]@row + VALUE([Risk score]@row + VALUE([Sub contract dependency score]@row + VALUE([Long term resiliency score]@row))))))
Thanks for any assistance you can provide.
Best Answer

Hi @jmoser
Your scores are obsiously string text and not numbers from the screenshot you provided. You should try to correct that.
Also, you have the parenthesis wrong on your formula. It should be like this:
=VALUE([Impact score]@row) + VALUE([SLO score]@row) + VALUE([Short term resilency score]@row) + VALUE([Risk score]@row) + VALUE([Sub contract dependency score]@row) + VALUE([Long term resiliency score]@row)
Another way to do it would be:
=SUM(VALUE([Impact score]@row), VALUE([SLO score]@row), VALUE([Short term resilency score]@row) VALUE([Risk score]@row), VALUE([Sub contract dependency score]@row), VALUE([Long term resiliency score]@row))
Hope it helped!
Answers

Hi @jmoser
Your scores are obsiously string text and not numbers from the screenshot you provided. You should try to correct that.
Also, you have the parenthesis wrong on your formula. It should be like this:
=VALUE([Impact score]@row) + VALUE([SLO score]@row) + VALUE([Short term resilency score]@row) + VALUE([Risk score]@row) + VALUE([Sub contract dependency score]@row) + VALUE([Long term resiliency score]@row)
Another way to do it would be:
=SUM(VALUE([Impact score]@row), VALUE([SLO score]@row), VALUE([Short term resilency score]@row) VALUE([Risk score]@row), VALUE([Sub contract dependency score]@row), VALUE([Long term resiliency score]@row))
Hope it helped!

Hi @David Joyeuse  you helped me immensely!
This one worked: =SUM(VALUE([Impact score]@row), VALUE([SLO score]@row), VALUE([Short term resilency score]@row) VALUE([Risk score]@row), VALUE([Sub contract dependency score]@row), VALUE([Long term resiliency score]@row))
Truly appreciate your timely response.
Jeff

The numbers may not necessarily be text values. It would depend on how they are populated. Numbers that are center justified do not denote text vs numbers.
Numbers are right justified and text is left justified except in the Primary Column where all values are left justified.
Of course this is all dependent on no formatting being applied to the column.
If your scores are in fact numbers, then you could actually drop the VALUE functions which would save you a little bit of typing, less parenthesis to fight with, and would be a little more efficient on the backend of things.
But with them being centered in the column there is no way to tell just by your screenshot whether they are text or numerical values.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!