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

MH2032

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

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.