Copy Row to another sheet depending on data entered

I have a form the different locations can fill out. Each location has their own sheet we track data on. I want to copy the row to the location sheet. I am not sure if this is possible because when creating a workflow, it only allows you to copy to one sheet.


Example: form entered for location A - I want to copy that row to Location A's master sheet. (form sheet may have 100+ rows from different locations)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!