JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Separate columns for input choices in Google SpreadsheetAsked by cheryl6922 on March 20, 2015 at 01:25 PM
Beautiful upload to my adobe form.... however I need separate columns for each choice in Excel, so I can sort the choices in Excel.. is there a formula - calculation that will separate the br into columns in Excel? I was having trouble with this issue in Cognito, which is why I'm trying Jot.... LOVED THE UPLOAD FEATURE.....
Thank you for your appreciation to our product.
Regarding the question, I would assume you are referring to the Google Spreadsheet integration, is that right? If you are looking on to separating the choices in the input fields to new columns, unfortunately if cannot be done automatically through our end.
But it is possible using some formulas in Google Spreadsheet.
I believe you are looking on to using the SPLIT function, you can learn more about it here: SPLIT on Google Spreadsheet
Another function that you might be interested is using the IMPORTRANGE, this will allow you to merge separate sheets to one. You can check it here: https://support.google.com/docs/answer/3093340?hl=en.
I hope this helps.