How to Maintain Formulas in Google Sheets?

  • Profile Image
    pc_performgroup
    Asked on November 15, 2017 at 02:30 PM

    Hello,

    I've linked a JotForm to a Google Sheet that contains a few formatting formulas.  These formulas have been copied down entire rows of cells.  However, it seems that JotForm inserts a new row and doesn't accept the existing formula.  The formulas are still in all the cells below the JotForm entry, just not in the entry itself. 

    Do you know how I can have new submissions accept existing formulas?

    -Thanks,

    Paul

  • Profile Image
    Nik_C
    Answered on November 15, 2017 at 03:41 PM

    We never advise editing or customizing the integrated spreadsheet since it could break the integration.

    But what I could advise you is to use importrange and import the integrated sheet into new sheet and do all calculations and formulas there, here is how: https://support.google.com/docs/answer/3093340?hl=en

    Additionally, you could share, your form ID and integrated spreadsheet to us, so we can check further.

    Thank you!