How do I set up sequential Smartsheet forms that take in inputs from the output of the other?

basicsmartsheet

Hi,

I have set up Form A that will take in inputs from a group of users (Users A). These answers will be logged into Smartsheet A and that is working well.

However, I have a problem. From the answers provided by Users A, I would need to populate one column (Project ID) from Smartsheet A/Form A as a drop-down list of Project IDs for Form B so another group of users (Users B) are able to access and fill in the form accordingly.

Would that be possible?

basicsmartsheet

These forms will be filled up sequentially (i.e. Form A will be filled in first, and Form B to be filled in later after Form A gets filled up).

Paul Newcome

So you just need a dropdown list on Sheet B to be updated with the project ids from Sheet A?

basicsmartsheet

Yes, Paul, that's right

Paul Newcome

You would need to leverage either the API or the premium app Data Shuttle for this.