Auto Number function not populating in numerical order

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

Hello,

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 :-)


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!