WBS Calculation

Vivien Chong

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.

Nick Korna

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!

Nick Korna

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!

Vivien Chong

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