Custom Numbering System


I am looking for a formula/set of formula to create a numbering system like 101, 102, 103. Unfortunately the way I need it to operate does not align with the auto numbering system feature.

Using a count(ancestors()) column formula, I am looking for the system to assign the first integer to the level 0 task, and then the 01 would be assigned to the subtasks below it. IE the second level 0 task would be 200, with all of the subtasks being 201, 202, 203,etc.

Similar to a WBS number system but slightly different.

Thanks for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!