We are creating a new Smartsheet to track deliverables. We have asked competing vendors to add delivery details within a ‘Smartsheet Form’ to auto-populate the sheet. Orders contain 1 to 100 shipments. Our Order Number is the same for all shipments. Ideally the vendor would like to enter the Order Number and the Order details once, then add the many delivery IDs in one Form. On the Smartsheet, the order header details populate the Parent row and the delivery details are the indented children rows.
Based on the feedback in this 4-year-old post (https://community.smartsheet.com/discussion/submitting-multiple-rows-form), I assume that this functionality is not available for Smartsheet FORMs? Do we need to get an excel report from the vendors, copy/paste into the smartsheet and indent the children rows manually? Or ask the vendors to submit up to 100 FORMs reentering the same Order details each time, one for each delivery ID? Are there any other options?
Thank you for your help.