Automatic item numbering

pjh

Enhancement request submitted.

Frank Falco

I have refined the code some more to account for deletions and additions and blank rows affecting the sequence.

Using the three columns, RowID, Level & WBS.

Task is the column with the Task Names in it.

$1 assumes you are starting on row 1, but change that if you are starting on another row.

RowID: =COUNT($Level$1:$Level@row)

Level: =IF(Tasks@row <> "", COUNT(ANCESTORS()) + 1)

WBS: =IF(Level@row = 0, "", (IF(Level@row = 1, COUNTIF(Level$1:Level@row, 1), "" + PARENT() + "." + COUNTIFS(Level$1:Level@row, Level@row, RowID$1:RowID@row, >(PARENT(RowID@row))))))

Hope that helps until the feature is added into SmartSheet

Andrée Starå

Hi Frank,

Nicely done!

Thanks for sharing!

Best,

Andrée

Karim Khan

Excellent!

pjh

Just curious, when will Smartsheet add this functionality instead of forcing users to implement code on every Gantt they (or someone in their organization) create? I've already submitted an enhancement request, and this feature has been requested for more than four years now! Can't someone from Smartsheet provide a proper solution for this?

m_barber

Is there a response to this? Timeline? 

AB

Good Day All:

 

I am visual person. Can someone share their she so I can see the layout and copy the formula for the WBS Code / Numbering? I tried the formula and I am getting an error.

Josh Garcia

Here you go. Credit to Frank Falco on the formula logic.

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

AB

Thanks but it wont let me copy. Can you provide Edit access and lock the column so i can just copy?

Josh Garcia

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

AB

Thanks and I figured out where I error, missing a comma and a parenthesis.

Jesse Kaser

Frank even with copying your code i still get an error message.

#UNPARSEABLE

CODE:

=IF(Level@row = 0, "", (IF(Level@row = 1, COUNTIF(Level$1:Level@row, 1), "" + PARENT() + "." + COUNTIFS(Level$1:Level@row, Level@row, RowID$1:RowID@row, >(PARENT(RowID@row))))))

 

Is there formatting on the sheet that needs to be done as well?  

 

asisson113596

Travis,

It's nearly four years since your first reply.  Seeing this Smartsheet is being touted as "Better than Ms Project" it would seem like something as simple and important as WBS numbering would be addressed, seeing as so many other users are having the same issue.

Update?

Thanks,

- Andrew