Parent Child Numbering

Options
Detrie Zacharias
Detrie Zacharias ✭✭✭✭✭

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

image.png


Best Answer

Β«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!