trouble with formulas applying to new entries from form

steve50951
steve50951 ✭✭
edited 12/09/19 in Formulas and Functions

I created a form. new entries are entered at the bottom of the form. I copied all of my formulas to the bottom of the form. When new entries come in from the form, they come in below the last row where formulas are copied. Result...formulas are not applied to the new entries coming from the form. 

How do I get the formulas to apply to the new entries coming from the form?

thanks, 

SGF

Tags:

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Can you post some screenshots of the sheet and give a rundown of where the formulas are supposed to be vs what fields are populated by the form?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Here are some screen shots. I locked the columns that have the formulas. I also posted several of the formulas that are being used. Basically the columns marked Upper 1 QTY, Upper 1 W, Upper 1 H, Upper 1 Sq In, Upper 1 Sq ft, & Upper 1 Total Sq feet, are duplicated for the rest of the sheet, only changing the # in the sequence. 

    The idea is that I created a form for our team to fill in measurements of a particular unit. Once the data comes into the sheet (through the form) the formulas would then make the necessary calculations to figure totals.

    Screen Shot 2019-02-26 at 2.09.39 PM.png

    Screen Shot 2019-02-26 at 2.10.09 PM.png

    Screen Shot 2019-02-26 at 2.10.33 PM.png

    Screen Shot 2019-02-26 at 2.10.58 PM.png

    Screen Shot 2019-02-26 at 2.11.12 PM.png

    Screen Shot 2019-02-26 at 2.11.22 PM.png

    Screen Shot 2019-02-26 at 2.11.31 PM.png

    Screen Shot 2019-02-26 at 2.11.46 PM.png

    Screen Shot 2019-02-26 at 2.11.55 PM.png

    Screen Shot 2019-02-26 at 2.12.08 PM.png

    Screen Shot 2019-02-26 at 2.12.17 PM.png

    Screen Shot 2019-02-26 at 2.12.30 PM.png

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    I noticed that you have rows collapsed. Are any of the collapsed rows blank?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • not currently. I deleted the empty rows created when the form added information to the bottom. When it added the information, it would typically leave 6-8 blank rows. I went back and deleted the blank rows it created. 

    Screen Shot 2019-02-27 at 7.22.29 AM.png

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    The problem is the Child Rows. The formulas will only pull down if the hierarchy is the same. New forms are on the very first level of hierarchy and have to be manually indented.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Gotcha. Ok that makes sense. So If I put all of the properties on the 1st level of hierarchy then the formulas will transfer down?

    SGF

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Correct. It is the indentation that is throwing everything off.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Hello - I am having the same issues however, I do not have any hierarchy or indentation used. Form entries are coming through to the sheet beneath where formulas exist. When I delete the formulas and re-save the sheet, the form entries continue to be entered below where the formulas used to be. Any ideas what could be wrong?

    Thanks!

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

    @Amie Dlouhy

    Hi Amie,

    Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    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.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    What exactly do you mean by this?


    "When I delete the formulas and re-save the sheet, the form entries continue to be entered below where the formulas used to be."


    What are the exact steps you are taking?

    To have a formula auto-populate into a row as soon as a new form is entered, you would need to have two rows containing the formula above the new entry.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!