How do you get a form to autofill the next set of numbers and repeat 1-50, 6 at a time?


We had a sheet that would automatically repeat numbers after a form submission (the form was just a checkmark box). The numbers were 1-50 and repeated 6 at a time. A user deleted some lines and now it has stopped working and I can't remember how to fix it.


  • John C Murray
    John C Murray ✭✭✭✭

    This usually happens when the numbers are generated by a cell-based formula. If that is the case for you then you need to find a cell with the formula in it (that cell will not be blank), and convert the cell-based formula to a column formula.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!