Using Datamesh then want to cell link to source so updates will appear in target

PDunn

I am using a master project list, filtering out certain jobs with a report, then using DataMesh to move the jobs onto a Intake sheet. I then want to cell link critical data from the source into the Intake sheet so any updates from the Master are reflected in the target sheet. I create the Inbound cell link, but when a new row is added to my target sheet via the DataMesh the cell link disappears. Why would this be occurring? Can I not use a cell link on sheets that new rows will be added?

Genevieve P.

Hi @PDunn

Right now, it sounds like you have the option to "overwrite existing data" selected, which means that the DataMesh is updating your manually cell-linked cells with the static copied information from the source sheet.

Instead of manually applying cell-links afterwards, what about using the DataMesh setting to automatically create cell links when it adds the row?

See:

https://help.smartsheet.com/articles/2483040-create-data-mesh-config#toc-step-5-define-view-options

If this hasn't helped, can you post a picture of your configuration like I have above?

Thanks,

Genevieve