Formulas on target sheet not continuing when rows are added via datamesh


When a new row is added via Datamesh to my target sheet, columns in the target sheet that contain formulas do not trickle down. This is something that is a non-issue if data is added via a form so I'm having trouble understanding why it's not working in Datamesh.


Best Answer


  • Mary_A
    Mary_A ✭✭✭✭✭✭

    Just curious, is Datamesh dropping the new data in the same location (sheet bottom or top) as the form? That might be a factor in the formula retention. I think the behavior is the preceding two rows have to have a working version of a formula for the added row to pick it up.

  • Noelle Harnish
    Answer ✓

    This problem has been solved with the release of column level formulas by SmartSheet in October of 2020.