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 1and 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 singledigit number it fails. If I use:
=VALUE(LEFT([Probability Score]@row))
Then I only get a singledigit 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.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives