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
 Smartsheet Customer Resources
 62.9K Get Help
 378 Global Discussions
 208 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!