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 back-end 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!