- CDUCAsked on January 10, 2018 at 01:47 PM
the problem we have is related to google spreadsheets, when exporting the form everything works fine, but we need to add 2 different boxes in which we must insert a formula, we have created these boxes with their respective formulas but when exporting the form these formulas are erased from the spreadsheet which means that we can not work properly since we need to keep these formulas in these boxes when exporting the form, so our question is whether it is possible to keep these formulas without being eliminated at the time of exporting the formula.
We need your help to solve our problem
- JotForm SupportTREVONAnswered on January 10, 2018 at 03:41 PM
If I am getting you correctly you want these formulas in the the text boxes to be used as formulas used in calculations in the Spreadsheet?
From my understanding is that if the textboxes are not filled with any data they will be exported as empty fields in the spreadsheet.
However if data is input in the textboxes in form of the formula then the text(Formula) inserted/typed in the textbox will be exported in excel sheet as any data entry and not as excel formula. It will show like text because it was inserted in the textbox as text.