How to do Auto Numbering Parent and Children rows separately?
Hi Smartsheet community!
I have an issue.
I need to use parent rows as separate projects and children rows as its tasks. That is why I need to have auto numbering separately for projects (parent rows) and tasks (children rows). Currently I use the "Auto Number" function. The only problem is that it does numbering of parent and child rows sequentially, so there is no differentiation between them only numbers. Are there any inbuilt function in Smartsheet that able to solve my issue?
Appreciate your help.
Thanks.
Answers
-
It wouldn't have all the parent ones or all the child ones be sequential but you could create a helper column that would reference your auto row and have it add something to the automation if it is a parent row and something different if it isn't the parent row.
example
=if((COUNT(ANCESTORS()) + 1)=1,"Parent" + [Auto Row]@row,"Child"+ [Auto Row]@row)
-
Hi Hollie.
Thank you for your prompt respond! I will check your advice.
Have a great day.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!