Parent Child Numbering


With A LOT of help from the community I was able put this together but, I think there must be a better way.

The last column is what I am trying to get to.

  • Auto-generated Sequential number in this format T-00001 when Ancestors = 0
  • Auto-Generated Sequential number in this format T-00001.1, T-00001.2 (where T-00001 is the Ultimate Parent) when Ancestors are NOT 0.

I have temporarily published it HERE with column comments

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!