Each option cost with its own column in the sheet would be great.

In order to have these calculatable in a spreadsheet integration, having each option cost with its own column in the sheet would be great, or alternately some sort of multi-sheet setup. F/E, I have a list of options but when using Sheets integration, the values aren't in the spreadsheet. My homebrew solution is to keep those items separately in a second sheet, but it means double-work and a double-place to change manage.

No, it doesn't show the calculation on the Spreadsheet integration. It only assigns a value and normally calculates it using Form Calculation widget.

You will only see the final / total value on the integration, but not the assigned value. Are you going to make a separate calculation in the Spreadsheet itself?

Please note that any modification to the current spreadsheet will break its integration so we suggest that you do your modification / calculation on another sheet.

Let us know if you have any questions or if you need further assistance. 

TL; DR: It doesn't break if you make mods, as long as the mods are consistent: IE, you can change a header name as long as you also change it in JotForm (I think headers are made from the form element name, not the unique ID name).

Values in data rows will not break the integration, but are probably also not back-processed to Jotform, so if you need to edit an order or whatever, I'd do it from Jotform and have IT update the spreadsheet.

Secondly, you can add sheets AFTER sheet 1 and it works fine. Not sure if "Sheet1" can be changed or not, but I'm not going to push it :).

______________________________ 

"Please note that any modification to the current spreadsheet will break its integration so we suggest that you do your modification / calculation on another sheet."

Can you elaborate? If I make a change to a cell, let's say I change a non-header row, Sheet1!A2 from a value of "1" to "2". Does this completely break the integration? Or do you just mean that if I add columns or modify header names that it will change?

As a second part to that: Let's say I have a form element that is named wrongly (common to have at least one when I have a huge number of them and use copy/paste). If I change the Sheet Header name to match the corrected name in the form element, does it also break?

I haven't changed the actual auto-generated things in "Sheet1" that Jotform creates, but I have added additional sheets, like so:

So that I can take all the form fields and do a cost estimation (that huge formula). This all happens on additional sheets (seen at the bottom) and I use things like "option_prices" to store costs associated with these multi-choice items. F/E, I use this:

(IF(REGEXMATCH(Sheet1!IB2, "Dessert bar"), option_prices!A52, 0)*Sheet1!K2)

To look for to see if "dessert bar" is one of the customer's chosen options, and if so multiply the cost (3.50 per person) by the estimated guest count (Sheet1!K2).

Do these things break my integration? I really hope not. If so, do I need to cross-reference the data from the sheet Jotform makes to a new sheet?

In order to prevent the integration to break, we do not recommend even slight changes on the sheet integrated with the form. Please have in mind that the integration may break, if you do any changes to the spreadsheet. We would suggest you to create a new Google Sheet integration, if you need to change anything on the form.

You need to keep the header part of the spreadsheet, where the field labels are place intact. If you modify any part of the header, it will break the integration. You need also to show all columns. You must not delete columns in the spreadsheet file.