How to transfer data from one sheet to another and then have it place in the correct place

I am trying to take data that is input in a form and managed in one sheet and automatically copy it to another sheet linked and input in a certain section based location criteria.

Here is currently what I am doing:


Sheet form data goes into that I want to use to manage a dashboard

Sheet that I want to automatically pull data into, and input into a certain area based on a common item (Weld002 for example)

Is possible to automate this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!