Have certain data go to various smartsheets based on form selection

Hi,

Is it possible to have certain data go to various other smartsheets based on a selection on a form selection? For example if on the form the user selects a Location of "Oklahoma" all the data on the form will go to a designated spreadsheet for Oklahoma data. While another option would be a Location of "Texas" and all the data on the form goes to the Texas spreadsheet.

My thought was to have all the data go to one spreadsheet then it gets linked to other spreadsheets based on the location selected.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!