WBS Calculation
I use the WBS template from Smartsheet. But find the WBS phase to be in error.
The formula: =LEFT(WBS@row)
How can I refine my formula so that it will capture the LEFT for WBS 1  9, but Abel to capture 2 digits numbers as well?
Thanks for any assistance and guidance.
Best Answer

Hi @Vivien Chong,
If your WBS column is only numbers/numbers with decimals then this would for you:
=IFERROR(VALUE(LEFT(WBS@row, FIND(".", WBS@row)  1)), WBS@row)
If there is a number with a decimal, the formula will find where the decimal point is and grab the numerical value. If there is no decimal point, then the whole number is taken instead.
Sample:
Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!
Answers

Hi @Vivien Chong,
If your WBS column is only numbers/numbers with decimals then this would for you:
=IFERROR(VALUE(LEFT(WBS@row, FIND(".", WBS@row)  1)), WBS@row)
If there is a number with a decimal, the formula will find where the decimal point is and grab the numerical value. If there is no decimal point, then the whole number is taken instead.
Sample:
Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!

Thanks @Nick Korna Yes you understood my question correctly. The formula works. Thanks.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!