SUM Formula generating "0" by using SUM Function for four columns
I have sheet, which is capturing data, within this sheet I have four formulabased 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 rightleft 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 rightleft 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.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives