How to pull info from one smartsheets column to another smartsheets column of the same name

Leila_19

Good Morning, Im having trouble pulling data from one column of one smartsheet and putting it in another column of a different smartsheet of the same name automatically.

Paul Newcome

There are a number of ways to do this. Are you able to provide more details? Have you looked into creating a row report?

Leila_19

No I haven’t looked into a row report. In my source sheet I put =INDEX({AA Number}, MATCH([AA Number]@row, {tester project Range 1}, 0))

I put that under AA Number column in source sheet

https://community.smartsheet.com/discussion/comment/392761#Comment_392761

Leila_19

Let me be a little more thorough. So I have one smartsheet(my source sheet) that has columns that need to be pulled to another sheet(destination sheet). Those columns on both sheets share the same name. The destination sheet has columns that aren’t on the source sheet so those don’t matters. I just need the columns that have the same names, i need that data to automatically populate on the destination sheet.

Paul Newcome

What is the reason for having it in a second sheet as opposed to using a report? What is the end goal for this second sheet?

Leila_19

It for shareholders to see all updates in one place.

Paul Newcome

If it is strictly for visibility, then I would definitely suggest a row report.

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

Leila_19

Ok i’ll check it out and let you know if it works. Thank you!