DataMesh not bringing over 0d when linking 2 project plans

I am using DataMesh to bring in tasks from one project plan to another. DataMesh is bringing over [Task Name], [Start Date] and [Duration], using a unique ID column as the Lookup Value

This works very well unless the source sheet has a duration of 0 days. If the source sheet has 0d in [Duration] it will lead to a blank [Duration] and thus a blank [End Date] in my Target Sheet. The blank [EndDate] in my target sheet is leading to my overall timelines being out of sync to the source sheet.

Source sheet example:-

Target Sheet Example:-

In the above example, the absence of 0d in duration is not giving an accurate [End Date].

Grateful for any suggestions on how I would resolve this,

Protonsponge

Find more posts tagged with

DataMesh

Accepted answers

Protonsponge

Hello @Georgie,

Thank you very much for coming back on my question, really appreciated. Also, thank you to @Britt Williams for discussing this with me during the week.

Both the source sheet and target sheet have dependencies enabled and in the source sheet and the source sheet have a lot of predecessors detailed.

I was actually able to a workaround on this just today. In my source sheet I made a "helper" column with the formula

=IF(Duration@row = 0, "0.0001d", Duration@row )

When I updated the data mesh config to bring the helper column in as the Duration to my target sheet, the duration read as 0 and still shows up as a Gantt view

Thank you again,

Protonsponge

All comments

Georgie

Hi @Protonsponge,

I’ve tested this on my end and I found that where my rows have a duration of 0 in the source sheet, the rows pull through to the target sheet with a blank duration, but the end dates are correctly populated. I was unable to reproduce the exact issue you’re seeing where end dates are either not populated (is that the case, or have you removed incorrect dates before taking the screenshot?) or populated incorrectly.

Do either of your sheets have dependencies enabled? I tried testing with dependencies enabled and disabled on the source sheet and saw the same behaviour as I described above, but I’m wondering if this could be a factor. Could you share some screenshots of your DataMesh config? Then I’ll be able to compare it to mine and see if there’s something different.

However, this may require further investigation from Support - you can open a support ticket so that your issue can be investigated by the team as soon as possible, but do share screenshots of your config if you’re happy to do so here!

Thanks,

Georgie

Protonsponge

Hello @Georgie,

Thank you very much for coming back on my question, really appreciated. Also, thank you to @Britt Williams for discussing this with me during the week.

Both the source sheet and target sheet have dependencies enabled and in the source sheet and the source sheet have a lot of predecessors detailed.

I was actually able to a workaround on this just today. In my source sheet I made a "helper" column with the formula

=IF(Duration@row = 0, "0.0001d", Duration@row )

When I updated the data mesh config to bring the helper column in as the Duration to my target sheet, the duration read as 0 and still shows up as a Gantt view

Thank you again,

Protonsponge

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.