i use a 2nd sheet to "clone" over data from the submitted form and do a
little clean up / translation on it.
a formula in the 2nd sheet something like:
=ARRAYFORMULA(IF(ISNUMBER(FIND("Yes", SubmittedData!E2:E)); "✓"; ""))
clones a continuous column with some translation (in this case changing a Yes
to a check mark).
you should be able to do something similar to change commas to semi-colons.
jay w.
> On Feb 9, 3:40 pm, martin <[email protected]
> <mailto:[email protected]>> wrote:
> > Using a google spreadsheet with a form for input to populate the
> > spreadsheet that is providing data for exhibit I find that when I use
> > the "checkbox" form field which enables a simple selecting of choices,
> > it will insert the choices separated with a comma, however the field
> > values need to separated with semi colons.
> > has anyone come across this and is there something I can do to make
> > this work?
> > Thanks for any help...
> > Martin
--
You received this message because you are subscribed to the Google Groups
"SIMILE Widgets" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/simile-widgets?hl=en.
