How to link cells from a form to automatically update in a separate sheet??

I am trying to link a couple of cells from a recruitment request form into a separate candidate tracker sheet. I am using the form template to keep track of recruitment requests and a task shee to keep track of candidate procedures. I was envisioning the candidate tracking sheet automatically updating when a recruitment request form is submitted. The only cells from the recruitment request form that would auto-populate into this candidate tracking sheet is name of the company and open position. I have tried messing around with MATCH/INDEX formulas but am just wondering if there is a simpler way to do this? I am struggling with how to correctly format these formulas...


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!