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

  • William Meixner
    Answer ✓

    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().


    =VALUE(RIGHT([Project Cost Score]@row,1))

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    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.


    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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!