- pc_performgroupAsked on November 15, 2017 at 02:30 PM
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?
- JotForm SupportNik_CAnswered 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.