Copy row automation isnt working from DataMesh sheet

NBW501

Hi - I have a sheet setup through DataMesh that links 10 columns from my source sheet. Then, I setup an automation to copy rows from the DataMesh sheet to other Smartsheets. However, the copy rows automation only works when I hit "run now" - it does not run when when triggered. My objective is to use the DataMesh sheet so I'm only sharing 10 columns on the other sheets vs the full 100. Does DataMesh not allow you to copy rows from its sheet or is it my automation that's not working properly? Please see the automation below and thanks in advance for your help!

kowal

hi @NBW501,

Few months back I created exactly the same situation. Data was transferred from one sheet to another using DataMesh and once the data was in the new sheet it triggered "copy the row" workflow to another sheet. It works perfectly for me so it shall work as well for you as well. I also set it up in DataMesh to update data immediately.

Did you contact the support already on that?

NBW501

Hi - It works when I hit "run now" but not automatically "when triggered" - It sounds like you were able to get yours to run automatically when triggered? Is your DataMesh set to Copy Data, Create Cell Links or Copy and Add Data? I've set up scenarios with all three and nothing seems to let me automatically trigger the copy row function.

I'm still working with my rep and support to figure out if it will work, so thanks for any other help you can offer.

kowal

Hi @NBW501,

I setup my DataMesh to copy data and it autotriggers the copy the row workflow.

I think maybe you shall contact Support as it' snot typical Smartsheet behaviour you are getting now.