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
-
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
-
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!
-
Thank you for the quick response!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!