Has anyone had any success with maneuvering around the fact that new parent rows created by a form and added to the bottom of a sheet will not inherit the formulas of the row above?
Here's the note from the Smartsheet help:
NOTE: Form submissions will always be fully outdented. If the last row in the sheet is indented in hierarchy, a form submission inserted at the bottom of the sheet will not auto fill the formulas or indentation of the previous rows.
I have users submitting change requests via a form and then I go and add the subtasks for that change as children rows under the change request parent. Once I've done that, then a new form submission doesn't pick up the formulas even though all the children of the parent above do. Do I really have to drag the formula manually every time?