Andrea

My feedback

  1. 12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Feature requests  ·  Flag idea as inappropriate…  ·  Admin →
    Andrea shared this idea  · 
    Andrea commented  · 

    - - - WORKAROUND - - -

    It is very simple, actually - - -> Use the SPLIT function.

    1) Go to the first empty column of your Form Response Sheet.
    Example = Col E

    2) In the first row (E1) put the following function:

    =split(A1,”,”)

    where A1 is the column where the responses of your checkbox are recorded.

    3) Now you will have the content of cell A1 divided in various cells.

    The number of cells depends on the number of options checked by the user in his response. Now you can also create bullet points!

    4) You can then combine these cells again.

    Example =B1&” “&C1” “&D1 will add a space and a coma between the cells.



    Au revoir

    Best,
    Andrea

  2. 9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Feature requests  ·  Flag idea as inappropriate…  ·  Admin →
    Andrea commented  · 

    - - - WORKAROUND - - -

    It is very simple, actually - - -> Use the SPLIT function.

    1) Go to the first empty column of your Form Response Sheet.
    Example = Col E

    2) In the first row (E1) put the following function:

    =split(A1,”,”)

    where A1 is the column where the responses of your checkbox are recorded.

    3) Now you will have the content of cell A1 divided in various cells.

    The number of cells depends on the number of options checked by the user in his response. Now you can also create bullet points!

    4) You can then combine these cells again.

    Example =B1&” “&C1” “&D1 will add a space and a coma between the cells.

    Andrea commented  · 

    The way checkboxes are managed atm is not really satisfactory.
    At least Google Sheet puts a Coma and a Space bettween different answers.

    Form publiher (I do not know why) just eliminates the space.
    As a consequence I somethimes find in my merged template a very long list of words only separated by coma. Totally unredeable.

    Maybe the solution is easy on this one. Bye!

  3. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Feature requests  ·  Flag idea as inappropriate…  ·  Admin →
    Andrea commented  · 

    - - - WORKAROUND - - -

    It is very simple, actually - - -> Use the SPLIT function.

    1) Go to the first empty column of your Form Response Sheet.
    Example = Col E

    2) In the first row (E1) put the following function:

    =split(A1,”,”)

    where A1 is the column where the responses of your checkbox are recorded.

    3) Now you will have the content of cell A1 divided in various cells.

    The number of cells depends on the number of options checked by the user in his response. Now you can also create bullet points!

    4) You can then combine these cells again.

    Example =B1&” “&C1” “&D1 will add a space and a coma between the cells.

Feedback and Knowledge Base