help with auto numbering my projects that have children and grandchildren

HLChristiansen

I want to assign project numbers to the main project, and then append that project number with .(letter) for the Subprojects, with Tasks still being assigned to the main project number, with the letter of the Subproject, and adding more hierarchy, such as

I'd like the task to read 40.c.1, or something similar that differentiates it from the Subproject, without completely disassociating from it.

Tasks are as far as the Hierarchy ever needs to go.

(The AutoNum column exists, but is hidden.)

Row Number	=MATCH(AutoNum@row , AutoNum:AutoNum, 0)
Ancestors	=COUNT(ANCESTORS([PROJECT NAME]@row ))
Sequential Number	=IF(Ancestors@row = 0, IFERROR(MATCH([Row Number]@row , COLLECT([Row Number]:[Row Number], Ancestors:Ancestors, 0), 0), ""), "")
Parent Name	=PARENT([PROJECT NAME]@row )
Child Number	=IF([Parent Name]@row <> "", RANKEQ([Row Number]@row , COLLECT([Row Number]:[Row Number], [Parent Name]:[Parent Name], [Parent Name]@row ), 1))
Hierarchal Number	=IF([Parent Name]@row = "", [Sequential Number]@row , PARENT([Sequential Number]@row ) + "." + CHAR([Child Number]@row + 96))

jmyzk_cloudsmart_jp

Hi @HLChristiansen

To meet the following requirement, you can use the JOIN(ANCESTORS())+ (delimiter) + Self structure.

'Tasks are as far as the Hierarchy ever needs to go'

[Level] =COUNT(ANCESTORS())

[Hierarchal Number] =
  IF(MOD(Level@row , 3) = 1, CHAR([Child Number]@row  + 64), 
  IF(MOD(Level@row , 3) = 2, CHAR([Child Number]@row  + 96), 
  [Child Number]@row ))

[WBS] =
  JOIN(ANCESTORS([Hierarchal Number]@row ), ".") + IF(Level@row  = 0, "", ".") + [Hierarchal Number]@row 

In the demo sheet below, I set the WBS so that it shifts from Number, Capital letter, and lower letter, depending on the hierarchy level.

https://app.smartsheet.com/b/publish?EQBCT=f60b55c4473b40dca80fa0b17885d64e

For more MS Project-like WBS control, here is a solution I developed before.

https://app.smartsheet.com/b/publish?EQBCT=1dd541e8ba7342dba52ed6b1872b748a