generate an automatic sequential numbering system under the WBS column
Answers
-
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
-
Hi @Tariq H
Smartsheet has an official template for WBS.😀
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.)
For more MS Projects like WBS, please read my article. (Originally for Japanese Users, translated into English.)
-
Please provide access to the template you mentioned. Thanks
-
Which template?
-
The above sheet is inaccessible. You may have to provide me with access in order for me to download the above.
Thanks
-
Ok. I got it.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives