Row ID - Automatic numbering Suffix for Childrows

AndreasP
edited 12/09/19 in Smartsheet Basics

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.

 

Comments

  • Andrée Starå
    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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 01/03/19

    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, [email protected])

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul Newcome
    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.

    thinkspi.com

  • 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. 

     

  • Will get back to you Andree. 

  • Andrée Starå
    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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.