Reference specific cells from a different sheet

Silvia Rangel

Hello smartsheet community!

Trying to figure out the best way to either reference or copy data from cells in one sheet to another. I can't use copy row because l only need certain cells from a row. Maybe a formula (VLookup?) that references the cells in the original sheet that will need to be brought into the new sheet? I am at lost how to even start... Thanks!

Jeff M.

How much data are you working with and how many rows would you need to apply this to?

You can right click on a cell and choose the "link cell" option to then select the cell to copy from the row/column on the sheet you need the data from. This cell will update every time the cell from the other sheet is changed/updated.

You can pull in data from multiple columns from another sheet into a single cell on another by using =JOIN(COLLECT(

Andrée Starå

Hi @Silvia Rangel

I hope you're well and safe!

To add to Jeff's excellent advice/answer.

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.

Another option would be to use so-called helper sheets. In short, copy the row to a helper sheet and then use my method described previously to get the values you need to another helper sheet and then copy/move the row from that sheet to the main destination sheet.

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

Silvia Rangel

Thanks @Jeff M. - Right now, it's just a handful but it will be way more. The original sheet tracks replacement jobs and contains a variety of columns for data required to manage the life cycle of the job. When a job meets a certain condition it's when said job moves on to a new scope and a different team takes over it and will be tracking it on a separate sheet but the identifiers will be the same as in the original sheet (work order, pole number, location, etc. ). I can't do a link cell because l don't know which cell/row it'll be the one changing scope, also because that means l have to manually do it every time a job changes scope. can't also do =JOIN(COLLECT( because l need to bring the data over to its corresponding cell/column.

Silvia Rangel

@Andrée Starå hello, long time no speak!

Would the cross-sheet formulas (VLOOKUP or INDEX/MATCH) work if there are only some of the rows in the source sheet that meet a condition are the ones that need to be pulled into the destination sheet??

I will give the helper sheet a try, not sure if it'd work as it's not really a 1x1 from source to destination sheets, as the trigger to copy a row needs to be if a condition is met.