It used to be that DataMesh would copy data from one cell to another per row. Lately, it has changed to updating an ENTIRE COLUMN if the value in ONE ROW changes. So instead of "1 row affected", it always thinks ALL rows are affected even if no changes are made to the other rows.
This then triggers notification automations and everyone is notified of the details on all rows :(
I could set it to "No" for the setting "Overwrite Existing Data in Target Sheet(s)" but we need the destination column to update if a change is made.
The source column is a column formula that combines multiple email address columns into one, as a text value. The destination column is just a blank contact column that allows multiple contacts.
The result of updating a single row:
Does anyone know if a system change was made or how to fix this, so that datamesh ONLY updates a single row when triggered by a single cell?
