Form flowing into bottom as child row

Lindsey P
Lindsey P ✭✭
edited 12/09/19 in Formulas and Functions

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

Comments

  • Andrée Starå
    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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Lee Joramo
    Lee Joramo ✭✭✭✭✭✭

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

    Nice Tip! Thanks

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Thanks!

    Happy to help!

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • 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å
    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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Debbie Sawyer
    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
    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
    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?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!