Cell reference - when original cell content is deleted, the referencing cell still shows value

Sylvia Kay

I have two Sheets. In Sheet A I have my full content. I am displaying some cell content from Sheet A in my Sheet B. I created the referencing as a Column Formula, so that if I add another row to my Sheet A, it automatically displays in Sheet B. That works just find.

What does not work is if I later on decide to delete a row in Sheet A. After I did that, the now deleted value is still displaying in Sheet B. My expectation would be that if it is deleted in the Source Sheet A, it would also not display anymore in Sheet B.

I am using the "link in from" another Sheet function.

Can you please advise?

Paul Newcome

Are you able to provide some screenshots for reference?

Sylvia Kay

Absolutely

:

Sheet A: The cell I am referencing is "Req ID"

Sheet B: The Referenced Cell Value is displayed in "Req.ID"

Sylvia Kay

So,

Sheet A "Req ID" contains an absolute number

Sheet B "Req. ID" (with the dot) pulls from the cell in Sheet A

Sheet B "Req ID" is a formula: "=[Req.ID]@row"

Paul Newcome

Do you have an example of the actual issue though? Where the row is deleted from Sheet A and the value is still showing on Sheet B?

Sylvia Kay

I can re-create it.

There are actually several issues at play:

1) The newly added value in Sheet A only pulls through sometimes to Sheet B. What I saw is that the "reference another sheet function" is not applied to an entire column, but only to teh fields that have a value in them when the reference is created - so it seems. It works when I create the reference for the first time, but thereafter the reference is not pulled over anymore - it is hard to show in a screen shot.

2) In case a value is update (e.g. deleted) in Sheet A, the corresponding Field is not updated to show an empty cell. My suspicion is the two issues have the same or a similar root cause.

I will later try recreate and add the images.