Hello,
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?
Cheers
