Cross Referencing Sheets

Tshelton

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!

Tim Shaded

It sounds like you could potentially try INDEX / COLLECT function for what you need. The key is that both sheets have to have columns with matching values for indexing specific rows. Below is a link to Smartsheet function list:

https://help.smartsheet.com/function/index

Tshelton

I will give that a try. Thank you!