Value Left - Working with single and double digits
Hello, For the below formula I am attempting to grab the leading numbers from an alphanumeric field. the numbers will always be leading but will range between 1-and 10.
I am using the following with no success
=VALUE(LEFT([Probability Score]@row, 2))
If the cell contains 10 then it works. But if it contains a single-digit number it fails. If I use:
=VALUE(LEFT([Probability Score]@row))
Then I only get a single-digit return.
I have attempted to use helper columns but to no avail yet.
The intent is to multiple two fields together using the formula above. See screenshot for reference.
Best Answer
-
This should remove the blank spaces on single digit values
=VALUE(SUBSTITUTE(LEFT([Probability Score]@row, 2), " ", ""))
Answers
-
This should remove the blank spaces on single digit values
=VALUE(SUBSTITUTE(LEFT([Probability Score]@row, 2), " ", ""))
-
Try this for your Column28. You should be able to use the same syntax for Column29
=VALUE(LEFT([Magnitude Score]@row, FIND("-", [Magnitude Score]@row) - 2))
Will this work for you?
Kelly
-
Many thanks for the quick assistance, but the options worked!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives