Formulas on target sheet not continuing when rows are added via datamesh
Options
Best Answer
-
This problem has been solved with the release of column level formulas by SmartSheet in October of 2020.
Answers
-
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.
-
This problem has been solved with the release of column level formulas by SmartSheet in October of 2020.