DataMesh Source Matches

Sara H

When using DataMesh, is there any way to identify which rows in the source sheet did NOT match on the target sheet?

Paul Newcome

It would be something along the lines of this for a flag type column:

=IF(COUNTIFS({Source Sheet ID Column}, @cell = [ID Column]@row) = 0, 1)

Paul Newcome

The only way would be to use a helper column with a formula containing a cross sheet reference. There is nothing built into Data Mesh to be able to identify that.

Sara H

@Paul Newcome Thank you. I will try that. I thought maybe I am was missing something. What would that formula look like if you were to write it out?

Paul Newcome

It would be something along the lines of this for a flag type column:

=IF(COUNTIFS({Source Sheet ID Column}, @cell = [ID Column]@row) = 0, 1)

Sara H

@Paul Newcome Thank you!!

Paul Newcome

Happy to help. 👍️