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

05/28/21
Answered - Pending Review

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

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Thanks Andree,

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

    Best,

    -Alice

  • 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

Sign In or Register to comment.