DataMesh

Man Chui

Hi,

1.) Could we use the "report" as Source Sheet ?

2) Can we create 2 DataMeshes with different Source Sheets but the same Target Sheet ? All the look up items will be the same. What will happen if Source Sheet 1 price is "$1.00" but Source Sheet 2 is "$2:00" ?

Genevieve P.

Hi @Man Chui

1. Yes you can use a Report as long as it's a Row Report! 🙂

Here's more information:

https://help.smartsheet.com/articles/2482785-datamesh-faq

2 . You can set up two workflows pointing to the same sheet. The value that will be pulled into the target sheet will be the one from the most recent workflow... so depending on how your workflows are set up, you may see the cell overwritten back-and-forth multiple times if there are different data entries. I would suggest using a Report instead so you can identify what to do when there are duplicates.

Cheers,

Genevieve