Questions on DataMesh

MMcLain
MMcLain ✭✭✭✭
edited 02/22/24 in Add Ons and Integrations

Dear All:

Good morning. We are VERY close to getting the approval from my top management for DataMesh - this is something I have been hoping to get for us since 2019. We were able to help 4 departments set up and become power users of Smartsheet last year. DataMesh will allow easier and faster inter-departmental data share.

There are a list of 14 questions that I would like to get answers to to seal the deal. Our account manager cannot justify the cost and make resources avaiable to get those questions answered for me at this time. Any input/insight you are able to share is greatly appreciated🙏:

  1. Does DataMesh allow folders for organization purposes?
  2. Does DataMesh have any limits on how many Configs one can set up?
  3. Can another licensed user set up a DataMesh Config that uses my Source as their Target Sheet, my Target Sheet as their Source and that process cancels what I set up to run?
  4. Can a DataMesh Config be duplicated, activated and deactivated?
  5. After a DataMesh Config is set, can additional Target Sheets be added as long as there are 5 or less?
  6. My trials show that when a Data Field in a Target Sheet is locked, data cannot be mapped/added, is that accurate?
  7. DataMesh allows the mapping of 10 fields, does the “Lookup Values” Field have to be one of those fields? Or can it be a particular value from a dropdown menu in a field?
  8. If more fields need to be mapped, is adding another Config the only solution?
  9. In my trials, if the Lookup Values are removed from the Target Sheet, it breaks the Config, running the config again won't add what was removed from the Target Sheet, please confirm if that is accurate.
  10. If the Lookup Values are deleted from the Target Sheet, is View Cell History in the Target Sheet the best way to retrieve and recover? Last year, the Product Team was working on a Sheet Change Report for Sheet owners, is that available now? If not, does DataMesh provide such a report?
  11. In my trials, a DataMesh Config can be transferred but not shared, is that true?
  12. Can reports or Excel files be downloaded for the following:

• Affected: 20

• Unaffected: 157

• Duplicates: 20

• Unmatched:

13. Can a deleted DataMesh Config be recovered?

14. Where are the deleted DataMesh Configs?

Thank you in advance.

Megan

Tags:

Best Answers

  • CodyRussell
    CodyRussell ✭✭✭
    Answer ✓
    1. No, there is no archive or recover feature that I've seen.
    2. Possibly, but it allows you to view up to 100 per page, so it would be a high limit.
    3. Datamesh is setup and managed per user. You can reference any sheets you have access to from viewer to admin rights. Another user's datamesh configuration wouldn't stop yours from running.
    4. Yes, they can be either manually run, run on a schedule. If you have it set to run manually, that's the same as "deactivated" as it won't run autonomously.
    5. Yes, you can select 1-5 target sheets per configuration.
    6. I just tried this and I can select lock columns to be mapped.
    7. You can map more than 10 fields, I map over to 78 in some configurations. The lookup value needs to be a data field/column.
    8. No, there is a button to add more fields to map.
    9. There are three settings you can use for this. "Copy and Add" will re-add data back into the target sheet as long as it exists in the source.
    10. If I understand this correctly, the same answer from question 9 is applicable here. You could also look into DataShuttle as a solution.
    11. This is correct.
    12. No, but it can be copy/pasted.

    These answers are based on my usage with Datamesh, and are accurate to the best of my knowledge...but I could be mistaken. Someone from Smartsheet would likely be able to confirm these and help with any other questions. :)

  • CodyRussell
    CodyRussell ✭✭✭
    Answer ✓

    Datamesh will override the column being locked and update the column values.


    I found this answer from a Smartsheet Employee back in 2022:


  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @MMcLain

    Creating a Report to filter your rows to only be the ones with "Pass" is exactly what I would have suggested. And yes! If you have multiple sheets to use as the source, combining them into a Report is the best way to do that.

Answers

  • CodyRussell
    CodyRussell ✭✭✭
    Answer ✓
    1. No, there is no archive or recover feature that I've seen.
    2. Possibly, but it allows you to view up to 100 per page, so it would be a high limit.
    3. Datamesh is setup and managed per user. You can reference any sheets you have access to from viewer to admin rights. Another user's datamesh configuration wouldn't stop yours from running.
    4. Yes, they can be either manually run, run on a schedule. If you have it set to run manually, that's the same as "deactivated" as it won't run autonomously.
    5. Yes, you can select 1-5 target sheets per configuration.
    6. I just tried this and I can select lock columns to be mapped.
    7. You can map more than 10 fields, I map over to 78 in some configurations. The lookup value needs to be a data field/column.
    8. No, there is a button to add more fields to map.
    9. There are three settings you can use for this. "Copy and Add" will re-add data back into the target sheet as long as it exists in the source.
    10. If I understand this correctly, the same answer from question 9 is applicable here. You could also look into DataShuttle as a solution.
    11. This is correct.
    12. No, but it can be copy/pasted.

    These answers are based on my usage with Datamesh, and are accurate to the best of my knowledge...but I could be mistaken. Someone from Smartsheet would likely be able to confirm these and help with any other questions. :)

  • MMcLain
    MMcLain ✭✭✭✭

    Thank you so much @CodyRussell!


    Regarding Item 6: I am able to map the field but data won't be added to a locked column in the Target Sheets. I am the owner of both the Source and Target Sheets.

    I can't thank you enough and please let me know if I can be of help in any way.


  • CodyRussell
    CodyRussell ✭✭✭
    Answer ✓

    Datamesh will override the column being locked and update the column values.


    I found this answer from a Smartsheet Employee back in 2022:


  • MMcLain
    MMcLain ✭✭✭✭

    Amazing find! Thank you so much @CodyRussell!

  • MMcLain
    MMcLain ✭✭✭✭

    @CodyRussell We got DataMesh! Thank you so much for your help!

    @CodyRussell @Genevieve P. and everyone else that's in the Mesh World:

    I have another question that I hope you have an answer to: I know I can match a column from a Sheet or a report to another Sheet, but can I pick and choose specific values in a column and only map the chosen ones (rows) to another Sheet? My experience so far has been no - I pretty much have to leveage a report (in which I can filter and keep only what I want) to map to another Sheet.

    Please also confirm for me: is it true that I cannot map multiple Sheets to one Sheet unless data from the multiple sheets are compiled in a report?

    Thank you again!

    Megan

  • MMcLain
    MMcLain ✭✭✭✭

    Please allow me to add an example:

    Column A in Target Sheet has: Pass, Fail, Dropped out (as values)

    I need to "copy and add data" to Source Sheets but only the rows that have "Pass" entered in Column A in Target Sheet.


  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @MMcLain

    Creating a Report to filter your rows to only be the ones with "Pass" is exactly what I would have suggested. And yes! If you have multiple sheets to use as the source, combining them into a Report is the best way to do that.

  • MMcLain
    MMcLain ✭✭✭✭

    Thank you for confirming that for me, @Genevieve P. !

    I have read the definitions of "Define View Options" many times, every time I seem to walk away with more ideas and questions.

    Would you be so kind as to clarify somethings for me?

    Overwrite Existing Data in Target Sheets:

    ** I usually choose "Yes" because I want mistakes to be corrected: I also add the Lookup Value as one of my data fields to be mapped. Do you recommend that the lookup value also be one of the mapped fields? I caught a few mistakes but also a lot of cleanup to do. I am still weighing the pros and cons of mapping the Lookup value.

    ** If I mapped 10 fields but only want 5 to be updated when there are changes, should I then select "No"?

    Duplicates in Source Sheet:

    ** When I select "Pick 1st Match", DataMesh updates all rows (duplicates with the same status even when the status of the first row should be kept the same). I think a synchronized archiving system will take care of that. Otherwise, if I select "Ignore Entries", does that mean duplicates will need to be updated manually?

    Data Mapping Format:

    Copy Data: I am not able to fully understand this because my testing hasn't showed me the difference between "Copy Data" and "Copy and Add Data". Is this more for a one-time mapping and is not good for Sheets or reports that continue to have new data added?

    Create Cell Links: I use this one when I only need to update statuses of mapped sheets. I have trouble deciding if "Copy Data" is better than "Create Cell Links" for the updates of a few fields. Removing mapped cells has to be done one cell at a time, is there another project offered by Smartsheet that can take care of link removal more efficiently?

    Copy and Add Data: I use this for most of the mapping I did. The source sheet/report keeps growing with new entries. This one seems to do the updates (changes of old rows) and add new rows.

    THANK YOU for making the archived answers available. It's been great fun and quite a learning journey reading others' exploration of DataMesh. Thank you again and have a great weekend!