Welcome!

Datamesh: Partial Success

tgiannelli

I'm working with Datamesh for some automations across some sheets for portfolio management.

I've got an Intake form as my source sheet and then another as my target for more detailed info.

I'm getting the Error! PARTIAL_SUCCESS each time it tries to run.

I cannot seem to find any documentation on this error message and how to clear it up.

Thanks,

Find more posts tagged with

Comments

Anthony M.

Hello,

It's possible this error is related to a mapped date column. Can you ensure that all your date columns associated with your Data Mesh configuration are set to Date column type and are not restricted to dates only?

Should this not resolve your issue. We will need to take a deeper look into your settings and sheets for the configuration. Please reach out to our support team for continued troubleshooting. https://help.smartsheet.com/contact

Kind Regards,

Anthony

Smartsheet Support

Jason Tarpinian

I'll throw in my experience with this too, same error, different solution than above. My issue was in the target sheet I had a column that was restricted to a drop-down list, and the source sheets had different data. I corrected it by turning off the restriction on the target sheet.

Jim Schaffhausen

Thank you Jason! I ran into this as well....

Melissa.Holland80446

Hi,

I am having this same problem. After some troubleshooting it seems that even if the column type is the same when you have the options restricted it will not allow the datamesh to run. Even if the dropdown options are the same in both sheets. Is that correct?

jwilson10533

Same ERROR. Nothing here new to take action on in terms of approaches above.. I do not have a restriction in target drop-down list fields. Data types the same where date columns. Help?

jwilson10533

I was able to resolve my ERROR due to the fact I was trying to bring across an End Date. If you only bring across (sync) the start date and a duration, the target End Date is calculated automatically and is therefore NOT needed in the mapping. I hope that helps other folks.

Sign in to join the conversation!

Quick Links

Trending discussions

Delete
How can I delete old sheets I no longer use from my account?
Using single-sign-on with external partners
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…