Is there any way to AutoNumber where the children are incremented from the Parent

I have Parent tasks that have the Auto-numbering for a unique Request ID. I have children under the Parent that are related to the Parent request. Is there a way to have the Child increment by 1 if a checkbox is checked?
Request ID is Auto-numbered "20010000". "20" for the year and then 4 digits for the Parent ID to increment and 2 digits that only increment for the children. If a child is added under a Parent can it auto-number only the last 2 digits from the Parent?
Parent 1: 20010000
Child 1: 20010001
Child 2: 20010002
Child 3: 20010003
Parent 2: 20010100
Child 1: 20010101
Child 2: 20010102
Child 3: 20010103
Parent 3: 20010200
Child 1: 20010201
Child 2: 20010202
Child 3: 20010203
I created a Child? checkbox to check and I can join or add the Request ID with the Child number but not sure how to get it to work where it is fully automated and using Column Formulas.
The below image is what I want the numbering to be but I can only get it to work with having formulas on the initial row which then I need to drag down the formulas in the helper columns and could cause user error.
Any ideas or changes to make it very user friendly where they only need to check a checkbox would be awesome! Also, sometimes a child may need to be inserted to an existing parent and we would still want to numbering to work.
Best Answer
-
I figured out a way with the checkbox. Thanks everyone!
Answers
-
Hi @Lori Hight,
Column formulas would work if the same formulas are used on every cell in those formula columns and this would remove the need to drag-fill the formula down. I think the tricky part here, whether you're using formulas to generate the numbers or the Auto-Number System Column, is that the auto-numbering will likely need to be reset for newly inserted rows that aren't coming into the sheet directly underneath the last used row.
More information on column formulas and auto-numbering can be found in the following Help articles from the Learning Center:
It's possible that some of the formula gurus here in the Community, such as @Paul Newcome and @Andrée Starå, may have some ideas for this but it may be worth Submitting a Product Enhancement Request to see about implementing some more Auto-Number settings to allow for more control over the numbers generated on newly inserted rows.
I hope this helps!
Thanks,
Ben
-
There are a few WBS solutions floating around here in the Community. You could take a look at those for some ideas as well. The ones that I have seen leverage hierarchy functions, so users would only need to indent and wouldn't have to worry about the extra checkbox.
-
Hi @Lori Hight
@Ben G Thanks for the Guru title! 👍️🧙♂️
Yes, I agree with Paul, and I might have an old solution that might work for this. I'll take a look in the archive and get back to you if it could work/help.
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
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.
-
I figured out a way with the checkbox. Thanks everyone!
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!