Auto Number function not populating in numerical order

Leah Taylor
Leah Taylor ✭✭
edited 03/21/23 in Formulas and Functions


Does any one know how to fix an auto number column that is not populating in numerical order?

See below screen shot, the 'Box number' column in an auto number column and when I populate the assigned to or the model cells the box number does not always populate the next number.

i would appreciate anyone's comments :-)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!