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

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hiya! This should now be resolved.

    In some instances, the cell link may need to be refreshed... you can do this by making any change to the source cell and saving.