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
Check out the Formula Handbook template!