How to do Auto Numbering Parent and Children rows separately?

Oleksiy Yefimov · 02/26/24

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.

Hollie Green · 02/26/24

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)

Oleksiy Yefimov · 02/27/24

https://community.smartsheet.com/discussion/comment/421859#Comment_421859

Hi Hollie.

Thank you for your prompt respond! I will check your advice.

Have a great day.

How to do Auto Numbering Parent and Children rows separately?

Answers

Help Article Resources

Categories