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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!