Linking Cells and then Sorting Source Sheet

I am working on creating a master list of events, that pulls data from 2 source sheets. I worked out the linking, but when the source sheets are re-sorted it messes up my links on the destination "master list". Is there a way around this? The source sheets are not able to remain static pages and will be used and updated periodically.

Any help is appreciated!

Find more posts tagged with

Sheets

Sharing and Collaboration

Formulas

Marketing

Cell linking

Media & Entertainment

Comments

J. Craig Williams

Can you provide screen shots or examples of your formulas?

Craig

EFHuey

I am not using any formulas, just the linking feature embedded in Smartsheet. Is there a better way to link cells ad sort both the destination and source sheets without messing up the linking?

Paul Newcome

If you are able to provide some screenshots, we might be able to work out a VLOOKUP or INDEX/MATCH function. That should give you the results you're looking for.

J. Craig Williams

I'm not sure I understand why sorting would mess up cell-linked values.

Are you sure it isn't messing up the value on the page you are sorting?

Craig

chasila

I think I might be having the exact opposite issue as EFHuey. Maybe. I'm linking several source sheets to a master sheet. Everything is date driven and I want to quickly add data to my source sheets and then resort them to make sure things are in data order. Because Smartsheets is linking specific cells (say A1-C6), I expected that when I resorted my source sheet, the master sheet where my linked data is displayed, would exactly reflect the link cells from the source sheet. So when I resort my source sheet, why do the linked cells not reorder on the master sheet?

When you sort a sheet, the row numbers stay sequential, so data is not always associated with the original row it was enter into.

Master Sheet.png

Source Cells.png

Sign in to join the conversation!

Quick Links

Trending discussions

Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…