Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    WBS Calculation

    ✭✭✭✭✭✭
    in Formulas and Functions

    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?

    Screenshot 2024-04-19 at 5.54.19 PM.png

    Thanks for any assistance and guidance.

    Vivien Chong

    Modern Work Management Consultant @ 57Network Consultancy Sdn Bhd

    Connect with us: 57network.com

    · Share on FacebookShare on Twitter

    Best Answer

    • Community Champion
      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:

      image.png

      Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!

      · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      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:

      image.png

      Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭✭

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

      Vivien Chong

      Modern Work Management Consultant @ 57Network Consultancy Sdn Bhd

      Connect with us: 57network.com

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions