Automating row expansion from Master sheet to Input Tracker using API or workflow

Amark

Hi Smartsheet Community,

I have a Master Tracker sheet where PMs submit projects via forms. Each row represents one project and includes:

• Auto-generated Project ID
• Total number of inputs (e.g., 3–5 inputs)
• Input 1, Input 2, Input 3… fields with descriptions and remarks

Currently, I manually copy each input related feilds into a second sheet called “Input Tracker,” where each input becomes a separate row linked to the same Project ID.

Example:

• One master row with 4 inputs → becomes 4 rows in Input Tracker

I want to automate this process so that when a new Master row is created or updated, it automatically generates multiple rows in the Input Tracker sheet (one per input), mapped to the same Project ID.

Questions:

1. Is this possible using Smartsheet API?
2. Would Data Shuttle be better than API for this use case?
3. Any sample code or recommended architecture would be helpful.

Thanks!

Paul Newcome

This is certainly possible with the API / Bridge, but you can also do this with just the core product if you have the appropriate architecture.

https://community.smartsheet.com/discussion/119380/split-multiple-selections-in-single-form-into-individual-rows-core-product

.