Used "Right" formula to put data in a range of cells then used SUM to add the data of that range.
I Used "Right" formula to put data in a range of cells then used "SUM" to add the data of that range.
I don't receive a valid number in the cell. The formula returns "0"
Above is the formula that pulls the data from the original cell to give me a number.
Above is the formula that I am using to try to calculate the sum of the range. All I did was use the "Formula" button and choose "Sum" and selected the range. But it just returns 0.
That's the whole sheet.
Best Answers

RIGHT() is a text command, so the return from this function is text. You would need to wrap that in VALUE() to convert the text output from RIGHT() into numeric, allowing then for SUM().
Example:
=VALUE(RIGHT([Project Cost Score]@row,1))

The reason this isn't working is because RIGHT is a text function, and SUM is a number function. RIGHT is pulling your numbers from the Project Cost column as text values, which SUM cannot add.
You could try wrapping the RIGHT formula inside a VALUE function, which should change it back to integer values.
=VALUE(RIGHT([Project Cost]@row, 1))
Provided your other column values are integers, your SUM formula should then work.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers

RIGHT() is a text command, so the return from this function is text. You would need to wrap that in VALUE() to convert the text output from RIGHT() into numeric, allowing then for SUM().
Example:
=VALUE(RIGHT([Project Cost Score]@row,1))

The reason this isn't working is because RIGHT is a text function, and SUM is a number function. RIGHT is pulling your numbers from the Project Cost column as text values, which SUM cannot add.
You could try wrapping the RIGHT formula inside a VALUE function, which should change it back to integer values.
=VALUE(RIGHT([Project Cost]@row, 1))
Provided your other column values are integers, your SUM formula should then work.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

@William Meixner and @Jeff Reisman Thanks your your comments  my form now works.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!