Linked cell does not update if data in source sheet is removed

I have a source sheet that milestones are added in relation to the date they take place. When that milestone pushes a week and we remove it from the source sheet it does not remove it from the linked sheet. If we change the data instead it will update so, I know the link works. It only is an issue if the data is removed. For now we are entering a "-" but, when I put the linked sheet in card view the "-" are represented as data and makes the card view look cluttered. I saw other posts similar to this but, have not found a solution.

Best Answer

Answers