Number not summing up, but combining?

Tvl_97

Hey everyone,

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

Jeff Reisman

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

Jeff Reisman

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

Tvl_97

Thank you for the quick response!