Datamesh to edit a column with a Formula


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
    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.

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

  • hi Jason

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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!