What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    Separate columns for input choices in Google Spreadsheet

    Asked 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.....

    Cheryl@okcrotary.com

     

    choices separate columns excel adobe form
  • Profile Image
    JotForm Support

    Answered by Charlie on March 20, 2015 at 03:15 PM

    Hi,

    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.

    Thank you.