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

Noelle Harnish
Noelle Harnish ✭✭
edited 06/14/22 in Add Ons and Integrations

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.

Tags:
· Share on FacebookShare on Twitter

Best Answer

Answers

  • Mary_A
    Mary_A Community Champion

    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.

    · Share on FacebookShare on Twitter
  • Noelle Harnish
    Noelle Harnish ✭✭
    Answer βœ“

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

    · Share on FacebookShare on Twitter

Categories

woman with hands out and open

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video