Generate rows equal to number from form


I'm trying to use a form to submit the number of rows that I want to populate, and I'm not too sure how, or if it's possible, to do so.

Essentially I'm looking to use the Auto Number column to generate ID's for a given number parts that I'm making. For example, I will make 3 parts today, enter "3" in the Form, then have the attached Sheet populate 3 rows with ID's 001, 002, 003. Then the following day say I'm making 4 parts, I enter "4" in the form and have 4 new rows populated with 004, 005, 006, 007.

I can get the Form to populate a single row, but I'm not familiar enough with smartsheet functions to get any further.

How might I go about this?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!