How to do Auto Numbering Parent and Children rows separately?

Oleksiy Yefimov

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

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

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.