Separate columns for input choices in Google Spreadsheet

  • Profile Image
    cheryl6922
    Asked 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

     

  • Profile Image
    Charlie
    Answered 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.