Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
numbering child rows
I have a sheet I've been using for a while. I just added a column and set it up to auto number. All the rows increased sequentially, e.g. 1, 2, 3 etc. The child rows, and their child rows continued in orer, in otherwords the child of parent row #1 was #2. I'd like the child of Row #1, to be 1.1 or something like that. Be even cooler if te child of the child ( grand child?) would be numbered 1.1.1 or 1.1.a
How could I do that?
Comments
-
What you are asking for is something llike a Work Breakdown Structure numbering or outline ordering system.
Not available directly
This can be built using formulas, but the overhead is typically not worth it, in my opinion, unless you finish the rest of the sheet, add in the formulas to get the results, and then turn them off (delete them - Smartsheet does not have a disable formulas feature) when you have the data.
Makes dynamic lists a pain, for many use cases.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives