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

Leila_19 · 08/28/23

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 · 08/28/23

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 · 08/28/23

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 · 08/28/23

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 · 08/28/23

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 · 08/28/23

It for shareholders to see all updates in one place.

Paul Newcome · 08/28/23

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 · 08/28/23

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

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

Answers

Help Article Resources

Categories