Renumbering Children

I am trying to figure out how to set up a column that would set a child's number. If the parent has 5 children then the numbering would be 1-5. If you inserted a child between 2 & 3 then that new record would become 3 and the rest would be 4-6.

I know I have to count the children but I am not sure how to identifies the records position within the order of children.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!