I have a parent row on a sheet and I would like new entries that flow into that sheet through a form to be automatically indented so it's a part as a child row to the parent row from the beginning. Also, there is a formula that isn't being pulled down to the new row right away. How do I get the formula to fill in? For example I want this formula to be in a cell right away, but right now I have to drag it down each time that a new row flows through the Form. Any suggestions for these two questions?
=[Forecast Amount]56 * Probability56