How do you get a form to autofill the next set of numbers and repeat 150, 6 at a time?
Options
We had a sheet that would automatically repeat numbers after a form submission (the form was just a checkmark box). The numbers were 150 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.
Answers

This usually happens when the numbers are generated by a cellbased 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 cellbased formula to a column formula.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!