Autonumbering of Children Items
Hi,
I have a sheet that has a number of parent items, and each parent has a list of its own children, this sheet also has a Number column. At the moment the use has to fill in the number automatically (i.e. 1,2,3, etc).
I wanted to have a column formula where any task added as a child task for a particular parent task will be numbered at an increment of 1.
Something like:
=IF(HAS([Description]@Row, PARENT()), Parent([No])+1, "")
Issues are:
- This is unparseable
- That would only work for the first child item, but not for the remaining
Any ideas would help.
Thank you.
Answers
-
I've done this before with a lot of helper columns. If somebody has discovered a more efficient method, please do share! Create the columns in the order below:
- "AutoNum" = create an # Auto Numbered column
- "UniqueID" =IFERROR(Primary@row + AutoNum@row, "")
- "ParentID" =IF(COUNT(ANCESTORS()) = 0, "Top", "R" + PARENT(AutoNum@row))
- "Child#" =MATCH(UniqueID@row, COLLECT(UniqueID:UniqueID, ParentID:ParentID, ParentID@row), 0)
The "Child#" field will then auto-calculate what number child it is, no matter how many levels of parent/children you could put on the sheet.
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!