How can I fill out columns in the sheet from another sheet?

YingHong Welday · 05/28/21

Hi Team.

I am working on integrating data from 2 sheets. For instance, in sheet 1 we have Project ID, Resource Assignment, Time Allocation. In sheet 2, we have "Project ID", "Category", "Product Manager".

I would love to make a sheet including below information:

"Project ID"( sheet 1) , "Category Name, Product Manager" (sheet 2), and Time Allocation (Sheet 1)

It requires me to use functions such as excel function "XLOOKUP", but I couldn't modify any of these sheets beside using them.

So I would need a solution to integrate the information from 2 sheets. My assumption would be using Report, but in the report they can only simply add up rows.

Thanks in advance.

-Alice

Andrée Starå · 05/28/21

Hi @YingHong Welday

I hope you're well and safe!

You'd need something unique to connect the records, and then you could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

YingHong Welday · 05/28/21

https://community.smartsheet.com/discussion/comment/293343#Comment_293343

Thanks Andree,

Is that possible to link a grid with another grid? Just like what we do in the report setup.

Best,

-Alice

YingHong Welday · 05/28/21

I am currently copy paste some static columns and use vlookup to retrieve the data from another sheet, the problem is that those columns are not next to each other, so it excess 100,000 cells according to the error pops up.

I need to match 2 condition to retrieve the target data.

Is there anyway / formula to fulfill this question? Thanks!

-Alice

How can I fill out columns in the sheet from another sheet?

Answers

Categories