Datamesh to edit a column with a Formula

hello

i d like to consolidate in a sheet data coming from 2 different sheets

Target sheet contains columns with Formula, and i d like to add automaticcally rows to that target sheet by using Datamesh. Columns are in same format

it seems that datamesh can't create rows if one of the column has a formula.

can you confirm ? is there a work around ?.

thank you

Find more posts tagged with

DataMesh

Accepted answers

All comments

Jason Tarpinian

That is correct, DataMesh will not overwrite a column formula. If you are looking to just create rows on the target via the source sheet, just update your DataMesh configuration to Copy + Add, and only map your lookup value column (and any other non-formulas). Then DataMesh will add the rows to the target, and your formulas will do the reset of the work.

Christophe29217

hi Jason

that s what i was suspecting, thank you for your quick answer

regards

Christophe

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.