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.

    Cheers,

    Genevieve

Answers