Cross Referencing Sheets

Options

Hi Everyone!

I am a new smartsheet user and I am looking to set up new project workspaces for network. I have a new client form created and I am trying to get those data fields to populate on another sheet. I have tried linking the cells, but when I save as new the links are removed. Is there a formula that I can use so that each time a new row is added via the form, the specified cells populate on another sheet? For example, I would like the client's first name from the form to populate in the client's first name field on sheet two and so on. I can't just copy the row as sheet two has additional columns that are not referenced in the sheet one form. Any assistance is greatly appreciated. Thank you!

Answers