# WBS Calculation

Options
✭✭✭✭✭✭

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.

• ✭✭✭✭✭✭
Options

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!

• ✭✭✭✭✭✭
Options

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!

• ✭✭✭✭✭✭
Options

Thanks @Nick Korna Yes you understood my question correctly. The formula works. Thanks.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!