Datamesh to edit a column with a Formula

Christophe29217

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

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