Row ID - Automatic numbering Suffix for Childrows
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
-
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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
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.
-
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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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