SUM Formula generating "0" by using SUM Function for four columns
I have sheet, which is capturing data, within this sheet I have four formula-based columns (Case 1: Score, Case 2: Score, Case 3: Score, Case 4: Score) which will produce either "1" or "0" based on the condition of the formula (and all these four columns type is text/number). I wanted to generate a total sum value of al these columns and have created an other column "Total Score", however when I apply the formula (=SUM([Case 1: Score]@row, [Case 2: Score]@row, [Case 3: Score]@row, [Case 4: Score]@row)) the answer was returning as "0" for every row which was not correct. Can someone please help me identify the issue?
Thanks in advance!
Best Answers
-
The SUM function only works on numeric values and it sounds as if you are summing text strings. If your Case 1 - 4 have scores that were arrived by a formula that produced a "1" or "0" (enclosed with the quotes), then you generated textstrings. They may look like numbers but the quotes made them behave as texts. If you haven't adjusted the right-left justification manually and the Score values are on the left, then they are text.
Kelly
-
Thank you so much! That helped.
Answers
-
The SUM function only works on numeric values and it sounds as if you are summing text strings. If your Case 1 - 4 have scores that were arrived by a formula that produced a "1" or "0" (enclosed with the quotes), then you generated textstrings. They may look like numbers but the quotes made them behave as texts. If you haven't adjusted the right-left justification manually and the Score values are on the left, then they are text.
Kelly
-
Thank you so much! That helped.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives