Pull data from a source sheet to a destination sheet with one condition

Julien smartsheet

Hi there.

I have an issue and I would like your help please!

You can find below the Smartsheet I have:

• I have a 1st Smartsheet "Source Smartsheet". In this Smartsheet, I have a list of projects with one line per project and multiple columns that are used to save the data for each project. I have one unique ID per project (column "VER ID");

• I have a 2nd Smartsheet "Destination Smartsheet". In this Smartsheet, I have another list of projects (most of them are part of the "Source Smartsheet") with one unique ID per project (column "VER ID");

You can find below what I would like to get:

• I would like to find a formula that can populate automatically the column "% Complete" of the "Destination Smartsheet". This data should be pulled from the "Source Smartsheet" by using the ID of the project which is unique in both Smartsheet (column "VER ID" in both Smartsheet).

I hope it makes sense.

Can you help me please?

Many thanks!

Andrée Starå

Hi @Julien smartsheet

I hope you're well and safe!

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.

=INDEX({ColumnWithTheValueYouWantToShow}; MATCH(CellThatHaveTheValueToMatch@row;{ColumnWithTheValueToMatchAgainsTheCell}; 0))

Depending on your country/region, you'll need to exchange the comma for a period and the semi-colon for a comma.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Julien smartsheet

Thanks Andrée !

I will try to use what you mentioned and come back to you with my update and probably more questions haha

Andrée Starå

@Julien smartsheet

Happy to help! Haha! Welcome back if needed!

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