generate an automatic sequential numbering system under the WBS column

System

This discussion was created from comments split from: Respective cells get blank.

Tariq H

G'day community, I'm trying to generate an automatic sequential numbering system under the WBS column. However, the formulas I've found on chatGPT don't seem to work. In this regard, I would appreciate some advice.

= "A" & (RIGHT([Previous Row Activity Number], LEN([Previous Row Activity Number])-1) + 10)

="A" & (1000 + (ROW() - 2) * 10

jmyzk_cloudsmart_jp

Hi @Tariq H

Smartsheet has an official template for WBS.😀

https://app.smartsheet.com/r/template-gallery/templates/dd318ca6-b1ec-4e1e-b31d-c8b0b3dc3a40/Project-with-Work-Breakdown-Schedule-%28WBS%29?tg-locale=en_US

The demo below is similar to your sheet, assigning a combination of 1000-digit numbers and a capital alphabet beginning with A according to the hierarchy structure. (I won't get into details of the formula. You can check the column formula by clicking the fx of the published sheet. If you have any questions, don't hesitate to ask.)

https://app.smartsheet.com/sheets/CpqvJRwMpQfrgrVR86JvGpHv3Vm2cf5cH6P5PqP1?view=gantt

For more MS Projects like WBS, please read my article. (Originally for Japanese Users, translated into English.)

https://cloudsmart.jp/en/smartsheet/templates/ms-project-like-wbs-template/

Tariq H

Please provide access to the template you mentioned. Thanks

jmyzk_cloudsmart_jp

@Tariq H

Which template?

Tariq H

The above sheet is inaccessible. You may have to provide me with access in order for me to download the above.

Thanks

jmyzk_cloudsmart_jp

Ok. I got it.