Row ID - Automatic numbering Suffix for Childrows

AndreasP

Hi Smartsheeters,

is there a way to use the auto numbering column with a logic to change the main "fill" part in respect to the parent row and the "suffix" part with the children? 

Lets say my auto-numbering has the following syntax: abc000-00

We have two parent rows with each 2 child rows. I want to see the following

abc001-00 (Parent)

abc001-01

abc001-02 

abc002-00 (Parent)

abc002-01

abc002-02

This would help referencing in a team as basically everything abc001- refers to one "project part"

Many thanks in advance.

 

Andrée Starå

Hi Andreas,

Unfortunately, it's not possible as far as I know at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Is this intended to be a reusable template?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Best,

Andrée

Paul Newcome

Andree is correct. SS does not currently offer any kind of WBS. I have created a system of formulas as a workaround though. It is not flexible, and the more levels you add, the more convoluted it gets. I quit after 1.1.1.1.

 

Depending on your use, it very well may be easier to manually enter everything.

 

If you don't mind lack of flexibility (doesn't hold up to sorting) and can get away with only 4 levels, feel free to check it out.

 

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

 

DISCLAIMER: It is ugly, bulky, inflexible, and convoluted. It is not a "pretty" solution. I cannot be held liable for any frustrations or loss of sanity that may occur as a result of use...

 

May the odds be ever in your favor.

AndreasP

Thank you all... 

Yes, my idea is basically having a Auto-numbering in combination with some kind of WBS system. I have worked with such clunky WBS formulas in Excel myself, and indeed it came to a point when frustration takes over the usefulness.

Will file an enhancement request. 

 

AndreasP

Will get back to you Andree. 

Andrée Starå

Hi Andreas,

How did it go? Did you manage to get something set up?

Have a fantastic week!

Best,

Andrée Starå - Workflow Consultant @ Get Done Consulting