Form flowing into bottom as child row

Lindsey P

Hello

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

Andrée Starå

Hi Lindsey,

Unfortunately, it's not possible at the moment to have the form submission indent automatically, but it's a great idea!

For the formula to fill there have to be at least two rows before or after with the formula. Most of my clients prefer getting the submissions in the sheet's top instead. I usually create two rows in the top and then hide them with a Default filter.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Lee Joramo

I usually create two rows in the top and then hide them with a Default filter.

Nice Tip! Thanks

Andrée Starå

Thanks!

Happy to help!

Best,

Andrée

Lindsey P

Thanks! I'm wondering why the formula isn't filling in. There are at least two rows before with the formula. Any other ideas to troubleshoot?

Andrée Starå

Happy to help!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Best,

Andrée

Debbie Sawyer

Hi Lindsey

Another reason why formulas don't always autofill is if you have deleted/moved the last row prior to the new record being submitted via the form. 

Some clients of mine had been getting data into sheets using forms and then moving the data to another location within the sheet (higher up - manually sorting the records).  Then when the next record is added via a form, the formulas stopped updating as the last row (i.e. the lowest row in the sheet) wasn't the last row (the one added most recently) anymore (as it was moved) so the formula didn't automatically update.  Hope this makes sense!

SO if you are moving the rows once they have been added (or if you have deleted the Last Row) then this would also explain why your auto-updating of formulas has stopped.

Hope this helps!

Kind regards

Debbie

Paul Newcome

The other problem is that it will only pull formulas from the two rows above that are of the SAME hierarchy level. So when the form is submitted it is at the parent hierarchy, but it is being populated below a child row. Therefore there aren't two rows above the new submission that are of the same "format".

Amanda Merrigan

We're having the same issue - although the row is being populated by MS Flow, not a Form. Should the same logic re: formulas in 2 rows above apply? We have a case where row 1 has a formula, row 2 has the same formula, row 3 (a child line) has the same formula and row 4 is populated by the Flow...however it is not grabbing the formula. Any thoughts?