Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How do I convert Text (from a count) to a number?
Comments
-
I've found this in Smartsheet Help \ Using Formulas where you may find the solution:
VALUE(): Converts a text value (that represents a number) to numeric formatCertain formulas will always return a value in text format, even if it looks like a number. For example: =LEFT(Cost5, 3)returns the value 425, which looks like a number but is actually stored in Smartsheet as text. Using text values in a calculation will return an error message about invalid data types. Use the VALUE formula to convert text to numeric format.- Example: =LEFT(Cost5, 3) * 4
- Result: #INVALID DATA TYPE
- Example: =VALUE(LEFT(Cost5, 3)) * 4
- Result: 1700
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives