Autoassign # based on parent or child (subitem)
I looking for a formula to autoassign a number based on the parent/child level.
For example, first level parent would be autoassigned zero (0). Any subitems would then be 1, 2, 3, etc. based on what level the item is listed under the parent. I've provided an example of how this would look, but I've manually entered in the 0,1,2,3, etc. in the 'Level assignment" column. I'm looking for a formula to replace the numbers in that column so I don't have to manually enter them when new rows and children are added to parents.
Thank you!
Best Answer

I don't see your attachment but if you are looking for any parent row to be a 0, any sub task to be a 1, any subsubtask to be a 2, and so on, this formula should work:
=Count(Ancestors())
Let me know if that helps or if you are looking for something different!
Answers

I don't see your attachment but if you are looking for any parent row to be a 0, any sub task to be a 1, any subsubtask to be a 2, and so on, this formula should work:
=Count(Ancestors())
Let me know if that helps or if you are looking for something different!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!