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

Noelle Harnish

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.

Noelle Harnish

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

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

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