Number not summing up, but combining?

Hey everyone,

can someone help me out and check why my numbers arent adding up, but combining instead?


Best Answer

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

    @Tvl_97

    This happens when one or more of the values you are trying to add is actually a text value. Smartsheet can't do math on text, so it concatenates it with the numeric value, as it would do with text. A number value stored as text will usually show up on the left side of the cell vs a true number value which would show up on the right side of the cell.

    To get around this, wrap the cell references in the VALUE function, which will change them into true number values. For example, VALUE([Cummulative number of weeks]280) + VALUE([Number of weeks]@row).

    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

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

    @Tvl_97

    This happens when one or more of the values you are trying to add is actually a text value. Smartsheet can't do math on text, so it concatenates it with the numeric value, as it would do with text. A number value stored as text will usually show up on the left side of the cell vs a true number value which would show up on the right side of the cell.

    To get around this, wrap the cell references in the VALUE function, which will change them into true number values. For example, VALUE([Cummulative number of weeks]280) + VALUE([Number of weeks]@row).

    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!

  • Tvl_97
    Tvl_97 ✭✭

    Thank you for the quick response!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!